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,175 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,364 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
963 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
648 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,527 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,870 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers