2016-08-16
115 reads
Editorials
Point-in-time data
Phil Factor explains why data detached from its temporal context often loses all meaning.
2016-08-15
80 reads
2016-08-15
81 reads
A Visit to Microsoft and SQL Server 2016
Today we have a guest editorial from Andy Warren as Steve is on vacation. Andy talks about a trip to Microsoft for the SQL Server 2016 launch.
2016-08-12
137 reads
An object lesson about what is really important
A story I heard a long time ago reminds us to choose what is really important.
2016-08-11
110 reads
Keyboard Hardlines
The potential vulnerabilities of wireless devices might be a security issue for databases.
2016-08-10
98 reads
Data Overload
When do you have too much data? What do you do if you aren't actually using all of it?
2016-08-09
78 reads
Making Complex Table Changes
The complexity of tables makes modifying them over time a challenge, especially as data sizes grow.
2016-08-08
58 reads
Security Shaming
This week Steve Jones looks at a new idea, rating the security of products publicly to try and shame vendors into more secure coding.
2016-08-08
85 reads
Failover
Too many failovers can cause problems, as can those that happen to often. Steve Jones says you need to consider whether you always need to failover in a sitaution.
2016-08-05
159 reads
Blogs
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
SQL Server Availability Groups
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Forums
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
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