Guess who's turning 25. SQL Server is celebrating 25 years

Guess who's turning 25.  SQL Server is celebrating 25 years since first shipped on the Windows Operating System with Windows NT in 1993.  


Other fun things
1
2
3
declare @greetings varchar(100)
SET @greetings= 'Happy 25th Birthday SQL Server'
SELECT @greetings
and another but it's just a Print statement:
1
PRINT 'Happy 25th Birthday SQL Server';







Comments

Post a Comment

Popular posts from this blog

Capture performance monitor counters using performance monitor

How to run performance counters on Windows Server 2008 R2 Today I needed to setup a configuration to mirror what someone had sent me so that I can estimate a baseline of disk performance to calculate disk IOPs for a SQL server move to a different datacenter.  This will only be a simple setup to get at the numbers I need so I can start the compare.  If I have more time I will show values and calculations in another post. 1. Open Performance Monitor by running PERFMON in the “Run…” textbox or navigating to Icon under all programs 2. Under “Reliability and Performance”, expand “Data Collector Sets”. 3. Right-click on “User Defined” 4. Select “New” from the popup menu then select “Data Collector Set”. 5. Assign a name for the new log settings. Eg.: “ServerName_Perfmon.” 6. Under the “Create data logs” section, check the checkbox for “Performance counter”. 7. Click the “Add…” button to start adding counters for each “Performance object” you wish to add counters from. Add ...
Read more

Trace Flag 8048 SQL Server 2012 prior to SP and Trace Flag 3449 after SP4

If you were using SQL Trace Flag 8048 and are now on SQL 2012 SP4 you don't technically need to be using this trace flag any more.  You can also enable SQL Trace Flag 3449. If you enable global Trace Flag 3449 (and you are on SQL Server 2012 SP4 or later or SQL Server 2014 SP2 or later), you will get much better performance by avoiding a FlushCache call in a number of different scenarios. Global Trace Flag 3449 takes effect immediately, with no restart required. You can set TF 3449 as a startup trace flag or in an Agent job using the following syntax:  DBCC TRACEON (3449, -1) Some of the main use case for Trace Flag 8048 in SQL Server 2012  as stated by CSS SQL Server Engineers : Backup Database Backup LOG Create Database Add file to Database Restore LOG (2 flushcache per restore log without recovery) Recover Database Shrink Database File SQL Server ‘graceful’ Shutdown SQL Trace Flag 8048 was first implemen...
Read more

How to Install SQL Server Service Packs and Cumulative Updates

Image
I am going to show around 90% of the screens once you have downloaded an update and will be using SQLServer2012-KB4091266-x64.exe which happens be the most recent at the time of this blog post On-demand hotfix update package for SQL Server 2012 SP4. You may have your favorite patching site that you prefer for SQL update, but here is an unofficial build chart lists site that has known Service Packs (SP), Cumulative Updates (CU), patches, hotfixes and other builds of MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, 7.0, 6.5 and 6.0 that have been released. Microsoft SQL Server Version List  https://sqlserverbuilds.blogspot.com/
Read more