Excel BI Tip #18: Using CUBE Functions to Break Out of Pivot Tables
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-02-04 (first published: 2015-01-27)
8,105 reads
DoD STIGs – Database Security Requirements Guide
Reading Time: 24 minutes
What are the Database SRG DoD Stigs?
The Database Security Requirements Guide, or SRG, is published as a...
2015-01-27
3,013 reads
Friends Of Red Gate 2015
I’m excited that I’ve been asked to be back involved for another year in the Friends of Red Gate program. This...
2015-01-27
524 reads
Friends of Redgate 2015
Reading Time: 2 minutes
It’s official, I am in Friends Of Redgate for 2015!
Ok, the last few months have been an...
2015-01-27
822 reads
Entity Framework 6 Interceptors
Interceptors in Entity Framework 6 allow you to hook in to before and after query events. The before events even...
2015-01-27
391 reads
SQL #58–Where are my own templates in SQL Server Management Studio 2012
The secrete SQLFile.sql
We are all so used to clicking on the New Query icon (or the keyboard shortcut Ctrl+N). We know it...
2015-02-02 (first published: 2015-01-27)
13,470 reads
T-SQL – Find Number of Rows of Database(s) tables Using Undocumented Procedure – sp_MSforeachdb and sp_MSforeachtable
On Technet forum, Op was looking for a way to get table cardinality for all databases in an instance. There are...
2015-01-26
791 reads
Clustered Columnstore Indexes – part 47 (“Practical Monitoring with Extended Events”)
Continuation from the previous 46 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is a continuation from the the post 44, where I...
2015-02-03 (first published: 2015-01-26)
5,780 reads
Downloading SQL Saturday data
I wanted to find out how many SQL Saturday’s I’d spoken at and how I ranked with others. I got...
2015-01-26
944 reads
An Overview on SQL Server Checkpoints
Commercial database systems like SQL server have many recovery mechanisms to restore data hardware or software failure. Checkpoints are part of such recovery mechanism.SQL Server Database Engine is programmed...
2015-01-26
25 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers