A SQL Server Bug and Data Security
A bug in SQL Server needs patching right away if you use TDE. Some data security issues concern Steve as well.
2017-09-25
36 reads
Editorial
Help from Cortana
Lots of work is going into making software more helpful. This week Steve Jones wonders what you want from these assistants.
2017-09-22
58 reads
The Avalanche of Cloud Computing
Today Steve Jones talks about the tipping point of cloud computing.
2017-09-21
53 reads
Interviews: What is ACID?
While thinking about interviews, Steve Jones shares a story of a job situation he encountered.
2017-09-20
123 reads
2017-09-19
63 reads
2017-09-18
62 reads
Avoiding the Hell of having to Remember DDL syntax
What's your favorite productivity tool when writing SQL? Phil Factor has has flirted with most of them, from templates and snippets to a programmer's clipboard and back again.
2017-09-18
106 reads
Voting for Change
Microsoft changed some things in SQL Server 2017 in response to community requests. Steve Jones is asking for more.
2017-09-15
51 reads
2017-09-14
91 reads
A Backup Change
Steve Jones talks about backup of data today and the challenges of managing this at scale.
2017-09-13
47 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers