Category: "SQL Server"
SQL Server 2014 has been released to manufacturing
Mar 19th
Yesterday, Quentin Clark, corporate vice president of the Data Platform Group, announced that SQL Server 2014 has been released to manufacturing and will be generally available on April 1. Quentin’s blog discussed the tremendous momentum with the SQL… more »
SQL Server 2012 System Views Map
Feb 20th
Something I forgot... we talk about, Christoph :-)
SQL Server 2012 System Views Map
The Microsoft SQL Server 2012 System Views Map shows the key system views included in Microsoft SQL Server 2012, and the relationships between them. The map is similar… more »
New Version of SQL Server Maintenance Solution by Ola Hallengren Now Available
Jun 4th
Ola Hallengren and his ongoing work of his SQL Server Maintenance Solution - SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs.… more »
Discrepancy by estimated TEMPDB space for CHECKDB and CHECKALLOC - WITH ESTIMATEONlY
May 17th
I came around this problem (depends on SQL Server 2008 R2 jutst to SQL Server 2012) by reading Paul S. Randal's and Ana's blog posts:
How does DBCC CHECKDB WITH ESTIMATEONLY work (Paul)
DBCC CHECKDB WITH ESTIMATEONLY: Do you trust it? (Ana)
DBCC… more »
SQL Server 2012 Tempdb File Size Change tracked with Extended Events
May 2nd
We are using SQL Server 2012 and the tempdb is growing so fast. How do I effectively find what’s causing my tempdb growing. Can I monitor the file size change with Extended Events to find out the ... more »
SQL Server Information
Feb 20th
Only a short script to get informations about your SQL Server enviroment, like machine name, instance name, edition, version, level, cluster security, user mode, collation and login. I use it as a piece on my whole admin scripts.
--> SQL… more »
SQL Server 2012 Service Pack 1(SP1) Customer Technology Preview 4 (CTP4) Available
Sep 21st
MICROSOFT® SQL SERVER® 2012 SERVICE PACK 1 (SP1), COMMUNITY TECHNOLOGY PREVIEW 4 (CTP4)
Download: SQL Server 2012 SP1 CTP4 SQL Server 2012 SP1 CTP4 Express SQL Server 2012 SP1 CTP4 Feature Pack
The SQL Server 2012 builds that were released after SQL… more »
Antivirus Software on SQL Server
Sep 20th
It’s an old story, but still present - Why or why not installing antivirus software on a database server? First of all, I’ve been on both sides of the debate with respect, but I can only, only partially agree to install antivirus software on a database… more »
SQL Server 2012 - New and Modified Dynamic Management Views and Functions - DMVs
Sep 13th
That's just about the limit. In Books Online for SQL Server 2012 (BOL) by reading What's New (Database Engine), I came around the topic Manageability Enhancements (Database Engine) and its paragraph New and Modified Dynamic Management Views and Function… more »
New Version of SQL Server Maintenance Solution by Ola Hallengren Now Available
Sep 10th
Ola Hallengren and his ongoing work of his SQL Server Maintenance Solution - SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs.… more »