Change Not For Replication Value for SQL Server Identity Columns
In this tip we look at how to change the SQL Server setting for a tables identity column to not for replication for existing tables.
2019-05-03
Additional Articles
Designing Highly Scalable Database Architectures
While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and has the capability to recover from a disaster scenario. In this article, Samir Behara discusses the options available when designing the database architecture to achieve scalability.
2019-05-03
Introduction to SQL Server Security — Part 5
SQL Server contains many built-in views and functions that can be used to understand what is going on “under the hood,” and security is no exception. In this article, Robert Sheldon explains the security related catalogue views, dynamic management views, and system functions
2019-05-02
Which Database is Causing the Problem?
You’ve got one SQL Server hosting a bunch of databases, and performance is bad. Which database should you focus on first?
2019-05-02
SQL Server Trigger on View Example
In this tip we look at how to create a SQL Server trigger on a SQL Server view.
2019-05-01
Compressed Microsoft SQL Server Backups by Default
Learn how to create default database compression for your SQL Server databases.
2019-04-30
Row Pattern Recognition in SQL
Itzik Ben-Gan asks you to invest in SQL Server's future by voting for Row Pattern Recognition, a potential T-SQL syntax extension he deems the next step in the evolution of window functions.
2019-04-30
Call SQL Server Stored Procedures with PowerShell using Parameter Objects
In this tip we look at how we can use PowerShell to validate input values into SQL Server stored procedures prior to execution of the stored procedure
2019-04-29
Processing Data Using Azure Data Lake, Azure Data Analytics, and Microsoft’s Big Data Language U-SQL
Data analytics has become one of the powerful domains in the world of data science. An enormous amount of data is being generated by each organization in every sector. Computer science has found solutions to store and process this data in a smart way through a distributed file system. One such example is Azure Data Lake. It uses the Hadoop Distributed File System, and to perform analytics on this data, Azure Data Lake storage is integrated with Azure Data Analytics Service and HDInsight. In this article, Suhas Pande will explain how to store data using Azure Data Lake and how to perform data analysis on it using U-SQL, a big data SQL and C# language.
2019-04-29
Parameter Sniffing in SQL Server 2019: Adaptive Memory Grants
This week, Brent is demoing SQL Server 2019 features that he's really excited about, and they all center around a theme we all know and love: parameter sniffing.
2019-04-26
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers