SQL Saturday Madison – Recap
A few notes from our trip to Madison for SQL Saturday. We arrived two days early and acted like tourist...
2014-04-01
763 reads
Blog Posts
SQL Server 2014 Install – Step by Step
Hot cake for the day is SQLServer 2014 RTM bits. Its generally available starting today, and I downloaded a fresh...
2014-04-01
19,248 reads
SQL Server 2014 New Defaults
Today, April 1st, 2014, marks the release of SQL Server 2014. There are tons and tons of great new methods...
2014-04-01
976 reads
SQL Server Installation Checklist
Many people have published SQL Server installation checklists before. Here is one I have been using for several installations without...
2014-04-01
20,799 reads
What is Program Database?
If you are working with .Net then you will be aware about PDB files.A PDB file is a Program Database,that is...
2014-04-01
731 reads
Cumulative Update #16 for SQL Server 2008 SP3
Here’s a link for the download for the CU #16 for SQL2008 SP3 http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/03/17/cumulative-update-16-for-sql-server-2008-sp3.aspx. The post also includes all the previous...
2014-03-31
1,278 reads
Default nullability of a new column
Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs?...
2014-03-31
1,196 reads
Default nullability of a new column
Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs?...
2014-03-31
1,041 reads
Follow Up on The Unusable User–Question Of The Day
I posted about one of my questions of the day called The Unusable User last week and wanted to return...
2014-03-31
1,202 reads
GetLogSpace – table and stored procedure
We’ve talked before about how to get log space usage information in SQL Server. After the 1,032nd time I re-wrote...
2014-03-31
1,262 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