Get database size, used space, free space
Gets the size, amount of space used & unused, owner and modify date for all databases in a Sql instance.
2015-09-14 (first published: 2014-04-22)
4,384 reads
Scripts
Deleting Duplicate Records
In Datawarehousing, a normal scenario is eleminating duplicate records/rows or deleting duplicate records, here's the solution.
2015-09-11 (first published: 2012-10-31)
5,012 reads
2015-09-10 (first published: 2014-05-08)
4,843 reads
Physical Server or a Virtual Machine?
Simple T-SQL Script to know whether your SQL Server is running on a Physical box or a VM.
Note: This Script works only on 2008R2 SP1 and above.
2015-09-09 (first published: 2014-05-22)
4,772 reads
Create MERGE statements with data!
A script to create MERGE statements with data for specific tables.
2015-09-03 (first published: 2014-05-19)
5,122 reads
SQL Server Performance Base Line Script
Performance Base Line Report from SQL Server DMVs and Perfmon counters
2015-09-02 (first published: 2013-02-04)
16,742 reads
Block altering indexed views.
Altering an indexed view will drop all indexes on it without warning, even if nothing is changed.
This will prevent accidental alters.
Script is divided into 4 parts, included testing and cleanup scripts.
2015-09-01 (first published: 2015-08-13)
969 reads
Registered server documenter
Returns server and instance information via a registered server query, regardless of SQL version.
This script is more of how to get the data, and not so much about the data returned by my choice of columns.
Tested on 2008+
2015-08-28 (first published: 2015-08-07)
1,309 reads
Generate Login Script(2008R2 And Older)
Generate Script from Logins of Sql Server to recreate in another instance
2015-08-25 (first published: 2015-08-10)
1,726 reads
Filestream and FileTable Implementation SQL Server 2012.
In this article, I would like to demonstrate about Filestream and FileTable implementation in SQL Server 2012.
2015-08-24 (first published: 2015-07-24)
1,510 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
Issue with Creating Linked Server from Azure SQL Managed Instance to On-Premises
Hi, Interestingly, I was able to create a linked server in the reverse direction—from...
SQL Monitoring tools
our client wants to implement Third Party SQL Monitoring tool to monitor SQL server...
PowerQuery.... don't meet SSIS
I have a powerQuery that reads and transforms a table in a PDF. Works...