Effects of sp_rename on Stored Procedures
There comes a time when mistakes are made. Sometimes those mistakes can be as annoying as a spelling mistake during...
2014-08-20 (first published: 2014-08-14)
13,819 reads
Blog Posts
ISPACs – Got To Love Em
Being a DBA and working with various teams, I have become accustomed to deploying SSIS packages. I’ll even go back...
2014-08-20
594 reads
SQLSaturday Orlando Marketing Plan-Part 37
I’m continuing to experiment with the messaging. Without A/B testing (and maybe even with, given the small list size) it’s...
2014-08-20
510 reads
Still a Need for a SQL Server Specific Organization
If you haven’t already, please read Denise McInerney’s post about why PASS no longer stands for the Professional Association for...
2014-08-20
662 reads
The End of The Professional Association Of SQL Server? It Should Be More Than Just An Acronym
I read with a bit of despair this post by Denise McInerney this morning. Going forward, it’s just “PASS”. Somehow...
2014-08-20
806 reads
The Red Gate Way…
As companies go, Red Gate is a little different. That is readily apparent in our tools and the philosophy behind...
2014-08-20
758 reads
Two years!
Two years ago today I began my blog with a post about the DEFAULT keyword. I set out with the...
2014-08-20
952 reads
Updating tsqlt
I was looking to write a new test with the tsqlt framework recently. I wanted to isolate a stored procedure’s...
2014-08-20
1,238 reads
VMworld 2014 Is Next Week
Can you believe that this year’s VMworld conference is just around the corner? It’s next week – August 24 – 28 – at...
2014-08-20
626 reads
Exception handling in SQL Server
SQL server gives the exception/error handling mechanism which is similar to c#, Try..Catch block. In SQL Server, we can write...
2014-08-19 (first published: 2014-08-11)
10,240 reads
Blogs
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers