Redgate Community Circle
I am very excited to announce that I will be taking my paid precon content “Tools for SQL Server Query Performance Tuning” and presenting it for free. This is...
2020-04-23 (first published: 2020-04-16)
166 reads
Blog Posts
SQL Prompt Fixes Poor Order By Coding
SQL Prompt is a fantastic coding aid, but it does more than format your code and provide intellisense. Over time, the team has enhanced SQL Prompt to also guide...
2020-04-23 (first published: 2020-04-15)
469 reads
A Bug in ‘Move All Your SQL Database and Log Files in Bulk’
It looks like we had a bug the in the SQL script in Move All Your SQL Database and Log Files in Bulk. No worries though, it’s all been fixed...
2020-04-22
16 reads
Daily Coping 22 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-22
8 reads
EightKB – A new virtual SQL Server event
With all the events that have been cancelled over the next few months due to the on-going COVID-19 crisis, Mark Wilkinson (b|t), Anthony Nocentino (b|t), and I wanted to...
2020-04-22 (first published: 2020-04-15)
271 reads
How SQL Server stores data types: DATETIME, DATE, TIME, and DATETIME2
This post dives into how SQL Server stores date and time data types in memory and on disk. But first, a note about endianness: CPUs manufactured by Intel and...
2020-04-22
154 reads
Jupyter Book Challenges in ADS
I was excited to try the Jupyter Book feature in the March Azure Data Studio (ADS) release. I’ve thought notebooks were an interesting way to teach and I’m looking...
2020-04-22 (first published: 2020-04-08)
322 reads
Running Azure SQL Database Edge on a Raspberry Pi
One of the coolest new projects out there is Azure SQL Database Edge: – https://azure.microsoft.com/en-us/services/sql-database-edge/ This allows SQL to run on ARM devices, just think how many devices are...
2020-04-22
228 reads
Running Azure SQL Database Edge on a Raspberry Pi
One of the coolest new projects out there is Azure SQL Database Edge: – https://azure.microsoft.com/en-us/services/sql-database-edge/ This allows SQL Server to run on ARM devices which will expand the range...
2020-04-22
5,370 reads
Coding Standards Gone Bad in SQL Server
Knowing your data is very important when it comes to writing code. Now I’ll admit that I am very far from being a developer, however as a DBA, I...
2020-04-21
5 reads
Blogs
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers