Collation considerations to create robust queries
Is your code "This" robust?What is Collation? In short words: are the sorting rules, case, and accent sensitivity properties for...
2018-06-11
164 reads
Is your code "This" robust?What is Collation? In short words: are the sorting rules, case, and accent sensitivity properties for...
2018-06-11
164 reads
Maybe some of you don't know this, but to view Report Definition Language reports (RDL) , you aren't forced to use...
2018-05-25
455 reads
Statistics are a vital part of SQL Server database engine, these are used for the query optimizer to create query...
2018-05-16
78 reads
Sample chart for quick insightsSQL Server Operations Studio will be a new tool for managing SQL Server, Azure SQL Database,...
2018-05-14
94 reads
If you work with multiple windows or make a change using SSMS to an object, sometimes IntelliSense does not reflect...
2018-05-08
244 reads
It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this...
2018-04-30
4,719 reads
I run a technical blog, so it is necessary to put code in almost every post. Most of the GUIs...
2018-04-25
75 reads
As any of the available SQL Server services, Reporting Services will use all of the server memory if needed, in...
2018-04-23
9,552 reads
A simple get-help output
PowerShell is a .Net based command line tool designed for automation.
It is recommended to script repetitive task...
2018-03-21
280 reads
If you encounter the following error trying to access reporting services:
User XXXX does not have required permissions. Verify that sufficient...
2018-03-02
120 reads
By Steve Jones
Today’s coping tip is to decide to lift people up rather than put them...
Tempdb is always a topic for me whether it’s in my sessions or blogs...
If you don’t have the backups of the certificate and private key from the...
Hi, I have just moved a DB from an old HP laptop, to a...
We’ve been running 400-instance clusters of t3.medium on an on-demand basis during the work...
I'm trying to develop a script that connects to SQL pulls in a list...