2012-06-26 (first published: 2012-06-07)
1,435 reads
2012-01-20 (first published: 2011-12-16)
1,008 reads
Return CSV column in separate rows
This script can be used to return a csv column such emails in separate rows
2011-12-26 (first published: 2011-09-14)
1,528 reads
2011-12-08 (first published: 2011-11-23)
1,128 reads
2011-08-04 (first published: 2011-07-25)
3,143 reads
2011-07-12 (first published: 2011-07-01)
1,126 reads
Remove tab,line feed and carriage return frome text field
Remove tab,line feed and carriage return frome text field
2011-04-28 (first published: 2011-04-21)
3,316 reads
2011-04-27 (first published: 2011-04-21)
2,735 reads
Query to get tables with no clustered indexes
Query to get tables with no clustered indexes(2K5,2K8,2K8 R2)
2011-02-14 (first published: 2011-01-28)
1,831 reads
2011-01-17 (first published: 2011-01-05)
7,093 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...