Cloud backup - MS StorSimple Applicance
In the previous post, I talked about how we can revamp the backup infrastructure for SQL to backup directly to Azure,...
2016-04-15 (first published: 2016-04-11)
2,204 reads
Starting with MS SQL Server
In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is SQL. Now let us start with basic of...
2016-04-10
40 reads
Starting with MS SQL Server
In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is...
2016-04-10
570 reads
XP_CmdShell isn’t Evil
Bonus summary: xp_cmdshell is limited to admins, unless you specifically grant permissions to users. And if you’re an admin, you have...
2016-04-14 (first published: 2016-04-09)
1,771 reads
VI Editor Basic Commands
A few months back I came across an instance of using VI Editor. Trust me being a SQL DBA it...
2016-04-09
5,098 reads
VMware CPU Co-Stop and SQL Server Performance (continued)
A number of you sent me some excellent questions about this topic, and my favorite asked me for the query...
2016-04-08
736 reads
Win a SQLBits Pass
You can win a free conference pass to SQL Bits, in Liverpool, May 4-7. It’s easy, just post a review...
2016-04-08
571 reads
SQLCover Code Coverage for SQL Server T-SQL
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage?
Code coverage is a way to see how...
2016-04-13 (first published: 2016-04-08)
4,421 reads
SQLCover Code Coverage for SQL Server T-SQL
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see...
2016-04-08
45 reads
SQLCover Code Coverage for SQL Server T-SQL
Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see...
2016-04-08
55 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers