(Priyanka Chouhan) Among other issues, blocked processes on the SQL Server (or SQL Server deadlocks) pose problems for database administrators (DBAs) since it is difficult to identify and monitor them. SQL Server DBAs often receive SOS calls complaining of slow running processes but before they can
Tag: sql server
Compress and Decompress in SQL Server 2016
(Dennes Torres) SQL Server 2016 ctp 3.2 is already available with a lot of news.
How to return a character string from a sql datepart using DATENAME
(Jack Vamvas) Question: I am using SQL Server 2012 date functions. I want to input a date e.g 17-Jun-1987 and create an output e.g Monday 17 June 2015.
SQL SERVER – Connecting to Azure SQL DB
(Pinal Dave) Learning new methods of working with SQL Server can always be challenging. I found the new learning coming my way while connecting to Azure SQL DB. I was confronted with an error and I was not sure where to start.
Implementing ‘Row Level Security’ (RLS) with ‘Block Predicates’ in SQL Server 2016 – Part 2
(Manoj Pandey) In my [previous post] I discussed about Row Level Security, its introduction, and a detailed demo on how to implement it.
Tuning : A Good Place to Start
(Tim Radney) I regularly get asked the question, “Where do I start when it comes to trying to tune a SQL Server instance?” My first response is to ask them about the configuration of their instance. If certain things are not configured properly then starting to look at long-running or high-cost quer
In Memory OLTP Changes in SQL Server 2016
(Rajendra Gupta) SQL Server 2016 In Memory OLTP has some new enhancements and we we will look at some of these new features in this tip.
SQLQueryStress: The Source Code
(Adam Machanic) Back in 2006, I created a very simple tool called SQLQueryStress. The goal of this tool was to enable the user to test a single query under some form of load — up to 200 simultaneous threads.
Azure SQL Database Resiliency – Business Continuity
(Marcin Policht) In one of the articles recently published on this forum, we have presented the point-in-time restore functionality incorporated into Azure SQL Database. Its primary benefit is the ability to recover from inadvertent database changes; however its applicability in the event of a disas
SQL SERVER – Free Database Search and Dependency Analysis
(Pinal Dave) This article covers the main features of ApexSQL Search, a free SQL Server Management Studio and Visual Studio add-in for SQL Server database object and text searching and for dependency analysis.