Cloud Backup - Directly to Azure
Backup is one of the major task for DBAs, it has many different options and ways for each companies to...
2016-04-07
1,639 reads
Quick Encryption with Always Encrypted
What do you need to do in order to access data in a SQL Server that’s encrypted with Always Encrypted?...
2016-04-06
834 reads
MongoDB – Local and Remote Connections in Mongo Shell
To Install and Getting started with MongoDB refer the below links
Getting Started with MongoDBInstall MongoDB 3.2 on WindowsInstallation Guide
How to...
2016-04-06
527 reads
SSMS Preview Plan Comparison Tool and Plan Viewer Optimizations
With the February release of the SQL Server Management Studio (SSMS) Preview Microsoft introduced a nice new tool inside SSMS,...
2016-04-06
707 reads
Ben Miller Speaking to oPASS & MagicPASS on April 19, 2016
Register to attend this joint chapter meeting at https://www.eventbrite.com/e/opassmagicpass-joint-april-meeting-w-ben-miller-tickets-24457339561.
OPASS and MagicPASS are proud to present a special joint meeting with Ben...
2016-04-06
566 reads
Name the schema when you create an object (or else)
This is one of those frequently ignored best practices.
When you create an object, specify the schema where it will...
2016-04-06
698 reads
SSIS Trick: Adding Multiple Packages to a Project
A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing...
2016-04-06
16,932 reads
TSQL– Search for Strings in Object Definitions
I have been working nn an environment that had multiple copies of a database on the same SQL server instance....
2016-04-06
348 reads
Tools of the trade
I’ve been meaning to write this post for a while now, nice and simple, just want to list the tools...
2016-04-06
526 reads
2016-04-05
5 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