SQL Server Management Data Warehouse (MDW) – Why it Rocks
Ensuring excellent performance for users and customers is a high priority for Database Administrators.
Today I want to share a free and easy...
2013-04-16
2,492 reads
SQL Server 2012 Diagnostic Information Queries (April 2013)
Here is the April 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-04-16
945 reads
Cumulative Updates - SQL Server 2012 RTM CU7
A 7th Cumulative Update is available for those users still on the RTM branch of SQL Server 2012. This is in keeping with Microsoft’s Incremental Service Modelling.
http://support.microsoft.com/kb/2823247You may have...
2013-04-16
10 reads
Find Largest Tables To Compress
In this post I’m gong to show some T-SQL that will show you the compression state of tables and how to quickly find objects that are worth compressing.
Last...
2013-04-16
7 reads
New SQL Server Cumulative Updates
Microsoft has released three new Cumulative Updates for SQL Server today, two for SQL Server 2008 R2 and one for...
2013-04-15
725 reads
Power Shell or Windows – Rebooting of servers local or remote computers
Rebooting of servers local or remote Using PowerShell and Windows
Powershell command
Start->Run->Powershell press enter
PS:\>RESTART-COMPUTER -COMPUTERNAME SERVER01, SERVER02,LOCALHOST
Windows Command
Start->Run->cmd press enter
c:\>shutdown /m...
2013-04-15
776 reads
The dangerous beauty of Bookmark Lookups
Every one of us knows Bookmark Lookups in SQL Server. They are great, because you don’t need to care about...
2013-04-15
752 reads
Customizing SSMS–Results
This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned...
2013-04-15
1,385 reads
SQL – DBCC CLEANTABLE – DROP UNUSED COLUMNS
Drop those columns which are no more in use.
For example, After Upgrade from MOSS 2007 to SharePoint Server 2010, we have...
2013-04-15
1,300 reads
Free SQL Server 2012 Installation Guide
Everyone’s favorite four letter word is back, FREE! Yes, it is time I gave back to the community since I’ve...
2013-04-15
359 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers