FileTable in SQL Server 2012
Among the many new features released in SQL Server 2012 is FileTable, which facilitates database storage of file and directory storage.
Comparing Table Variables with Temporary Tables
This articles brings a comparison of temporary tables with table variables from SQL Server author, Wayne Sheffield. In includes an in-depth look at the differences between them.
Interns
Today we have an editorial from Aug 8, 2007 that is being republished as Steve is on holiday. This piece looks at interns and how it's a good idea for finding new employees.
Handling Deadlocks in SQL Server
In this excerpt from his book Troubleshooting SQL Server: A Guide for the Accidental DBA, Jonathan Kehayias provides a guide to identifying the causes, reacting to, and ultimately preventing the dreaded deadlock.
Learn in the Margins
It can be very hard to find time to learn new skills and get better at your job. Today Steve Jones talks about finding a little time in the margins of your life.
Re-compilation and Its effects on Performance
How recompilation does significantly affect on the execution time of SQL query and plummet or degrade the performance?
Securing the Tabular BI Semantic Model
This paper introduces the security model for tabular BI semantic models in SQL Server 2012. You will learn how to create roles, implement dynamic security, configure impersonation settings, manage roles, and choose a method for connecting to models that works in your network security context.
The Platform as Code
Today Steve Jones talks about the need to understand code to be a good administrator. Our systems are more complex and we cannot manage multiple systems by clicking on buttons in an interface.
When did this DB property Change?
Learn an easy way to determine if and when a database property has changed in any of your databases.
SQL Server 2012 Integration Services - Package and Project Configurations
Marcin Policht examines SSIS 2012 package and project configurations, which offer different ways of modifying values of variables and parameters without having to directly edit content of the packages and projects of which they are a part.
Blogs
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
Using AI for Git Hooks
By Steve Jones
Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....
Forums
SQL Agent job running gMSA cannot backup to NAS target
I'm running a group MSA for the database engine and SQL Agent in a...
sys.query_store_query question
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Encoding Strings
Comments posted to this topic are about the item Encoding Strings
Question of the Day
Encoding Strings
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers