All about Searching - Full-Text Indexes
SQL server has the capability to store text-based data in the form of char, varchar, nchar, nvarchar, text, ntext, image,...
2016-04-07
1,879 reads
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,643 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
836 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
711 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
567 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
700 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,946 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
531 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
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...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers