(Pinal Dave) I really like my work as every single day I get to see different SQL Server and new interesting problems to solve when I work with Comprehensive Database Performance Health Check. Recently, while working with a client we noticed that they have a huge index with a first key column as uni
Tag: sql server
(blobeater) The Azure SQL Database service triggers an automatic failover after a failure is detected and the grace period has expired. What is the grace period?
(Rick Dobson) What are the different types of SQL Server user-defined functions? What are special syntax rules for creating and invoking each major type of SQL Server user-defined function?
(Grant Fritchey) Those my friends are, in my opinion, one of the single most wonderful things on earth, white chocolate macadamia nut cookies.
(Pinal Dave) The other day during one of my old clients sent me an email about if I know any trick to get the second row from the resultset. I know why he was asking this question as I had worked with him before Comprehensive Database Performance Health Check.
(lukaseder) One of Java’s big strengths, in my opinion, is the fact that most naming conventions have been established by the creators of the language.
(Eli Leiba) The requirement is to create a T-SQL script to report when a SQL Server Windows login password will expire.
(Ranga Babu) In this article, we will review how to set up Geo-Replication on a Transparent Data Encryption (TDE) enabled Azure SQL database.
(Pinal Dave) Just another day in my life when I got involved in the SQL Server Performance Comprehensive Database Performance Health Check, where I ended up with a server with a high amount of malicious Wait Type. In this blog post, we will learn about how to fix the performance issue with the malic
(Itzik Ben-Gan) The ROW_NUMBER window function has numerous practical applications, well beyond just the obvious ranking needs.