Holidays and Parties, Gift, Expectations, and Wishes
Most companies do something at the holidays, although it seems to be less with each year, and certainly this holiday...
2009-12-18
1,484 reads
Articles
Understanding SQL Server fixed database roles
I know there are fixed database roles that come with SQL Server. How do I best use them within my installations? What should I watch out for? In this tip we will cover each of the database roles and recommendations on when to and when not to use them.
2009-12-18
3,959 reads
Yes, Table Variables and Temp Tables both use the tempdb
Pinal Dave recently wrote a blog post called SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth...
2009-12-18
2,207 reads
Dissecting SQL Server Execution Plans
A review of MVP Grant Fritchey's "Dissecting Execution Plans". This is one book that you'll want on your bookshelf.
2009-12-17
5,812 reads
Using a Certificate Signed Stored Procedure to Execute sp_send_dbmail
Learn how to create a certificate signed stored procedure to solve common permissions problems using sp_send_dbmail. MVP Jonathan Kehayias brings us a short tutorial that discusses your options and code to show you how to implement certificate security.
2009-12-17
10,607 reads
Architecture Principles
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
2009-12-17
1,694 reads
Architecture Principles
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
2009-12-17
3,464 reads
Architecture Principles
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
2009-12-17
1,567 reads
Tally Table - Character Date Validation
Tally (or numbers) tables are one of my favorite query writing tools. Such a simple premise that can be applied...
2009-12-17
3,185 reads
Tool to help you analyze SQLDIAG and PSSDIAG output
SQLDIAG or PSSDIAG are excellent tools used to collect and analyze data in order to identify possible performance root causes. The issue is that the output produced by such utilities is sometimes convoluted, hard to read and hard to understand. In this tip, I will show you a tool that you can use to read and analyze the data collected by these tools.
2009-12-17
2,873 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers