Proper configuration of the TempDB system database is crucial for optimal performance of a SQL Server instances during heavy loads. The recommended...
2016-02-04 (first published: 2016-01-31)
8,188 reads
It’s the first day of the year 2016 and I’m thinking about all the SQL events I attended in 2015.
SQL Sat...
2016-01-01
521 reads
My previous post was focused on controlling read operations. With the latest enhancements to the row-level security, it is now possible...
2015-12-03 (first published: 2015-11-29)
2,796 reads
Row-Level Security (RLS) is a new feature of SQL Server 2016 and Azure SQL Database that enables data access control based...
2015-08-28
3,377 reads
In the on-premises world, when we install a SQL Server on our own servers, we decide on SQL Version (2012, 2014….), Edition (Standard, Enterprise,...
2015-06-10
23,103 reads
There are two flavors of SQL Server in Azure: one is the traditional SQL Server platform hosted in Azure virtual machines,...
2015-05-09
964 reads
The number of Microsoft’s cloud services is growing by month, if not week, so that it’s hard to keep them all...
2015-05-03
649 reads
Lookup is one of many transformations available in SQL Server Integration Services (SSIS). Its purpose is to perform a JOIN of...
2015-04-29
17,541 reads
Starting with SQL Server 2008, we can use the MERGE statement to solve some every day scenarios in more elegant...
2015-04-20
2,284 reads
You can easily determine whether existing stored procedures, UDFs and views can work in a higher (or lower, if you wish) compatibility...
2015-04-13
4,881 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...