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
The Real Reason You Should Be a Proactive DBA
If you’re reading this, you probably think, like me, that SQL Server is an awesome product. One of the great...
2014-08-11
1,394 reads
SQLSaturday Baton Rouge Business Intelligence and Recap - 1 of 2
(This is the first part of a two-part post on a SQLSaturday Baton Rouge 2014 recap.)
Been quiet on this blog...
2014-08-10
749 reads
SQLSaturday Baton Rouge Business Intelligence and Recap - 2 of 2
(This is the second part of a two-part post on a SQLSaturday Baton Rouge 2014 recap.)
Out of a total of...
2014-08-10
572 reads
Clustered Columnstore Indexes – part 37 (“Deleted Bitmap & Delta-Store Sizes”)
Continuation from the previous 36 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Since the very first CTP beta, I have been asking for some...
2014-08-10
186 reads
My articles published on SSWUG.org from March 2014 to July 2014
The following is the list of my articles published on SSWUG.org from March 2014 to July 2014. To read these articles, you must have SSWUG.org standard-level membership. SQL Server...
2014-08-08
8 reads
My articles published on SSWUG.org from March 2014 to July 2014
The following is the list of my articles published on SSWUG.org from March 2014 to July 2014. To read these...
2014-08-08
879 reads
Reblog: August 1 to August 7
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-08-08
813 reads
Upcoming PASS Virtual Chapter Webcast (FREE!!!)
As always, there are many free ways to learn more about SQL Server and the Professional Association of SQL Server...
2014-08-08
687 reads
Friday Followup For August 8, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-08-08
396 reads
Blogs
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...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
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