An Introduction to the SQLCMD Mode in SSMS (SQL Spackle)
Using SQLCMD Mode in SSMS is easy. This short piece will show you how to get started.
SQL Solutions Group Marks 5th Anniversary with SQL FreeCon
To mark five years in business helping companies across the United States with their SQL Server needs, SQL Solutions Group will host a day of free SQL training Tuesday, Oct. 27, in Seattle.
Where should middle tier business logic be stored?
The age old question of where should business logic be stored
Idle Connection Resiliency
Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.
The Poor Soul
What should those accidental DBAs do when they don't get any training, but they are responsible for database servers? Steve Jones has a few pieces of advice today.
Integration Services Logging Levels in SQL Server 2016
At the time of writing, SQL Server 2016 preview (CTP 2.3) has been released and there are some changes for the Integration Services (SSIS) Catalog logging levels.
SQL Prompt Tips #1 - Selecting in the Object Explorer
A quick tip to help you get the most out of SQL Prompt.
Azure SQL Database - Row-Level Security
One of the benefits of using Azure-based Platform-as-a-Service and Software-as-a-Service offerings, is considerably quicker access to newly developed capabilities. In this article Marcin Policht focuses on row-level security, included in both Azure SQL Database V12 and SQL Server 2016 Community Technology Preview 2 (CTP2).
Find Permission Changes In The Default Trace
Learn how to find who has changed permissions from the default trace
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Jabatan Imigresen Certified Translators: Trusted Support for Official Documents
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers