SQL Server Blog

Show Database last access time

Here is a script that I use to get info of when a database has last been accessed without having to set up a trace Note : It gets it in...
Handy - SQL Scripts to show high CPU usage

The first query will order the results based on the queries that have used the most CPU time since the SQL Server instance has been restart...
Replication & AlwaysOn Availability Groups

Replication supports the following features on Availability groups: A publication database can be part of an availability group. The publi...
Tuning the Performance of Backup Compression in SQL Server

Here is a great read on Tuning the Performance of Backup Compression in SQL Server http://sqlcat.com/sqlcat/b/technicalnotes/archive/2008/...
SQL Server codename “Denali” CTP3

SQL Server codename “Denali” CTP3 has been released to the public after much anticipation. You may ask yourself, “What happened to CTP2?” Th...
SQL Enterprise to SQL Standard - Handy Script to remove compression.

The following script displays the indexes and tables that use compression and generates a script that removes the compression. SELECT ...
DMV - SPROC with the highest average CPU

This handy bit of code shows the stored procedures with the highest average CPU time in SQL Server.. SELECT TOP 50 * FROM (SELECT OBJEC...
Virtual Infrastructure SQL Server won't start after SP Install

As your virtual infrastructure is growing and changing rapidly a result is that the configuration of your SQL Servers could be changing al...
Free SQL Server Tools, Software and Utilities

Free SQL Server Tools, Software and Utilities http://www.sqlserverutilities.com/SQL-Server-Utilities-Free-SQL-Server-Tools-Software-and-Ut...
Link to a great article, that explains each flavor of Power BI and their associated pricing

http://blog.exposedata.com.au/2018/04/05/power-bi-cheat-sheet/

Lock it in :

Posts

Atom

Posts

All Comments

Atom

All Comments

SQL. Awesome Inc. theme. Powered by Blogger.