No moving parts, the story of persistent memory
In November 2017, during the PASS Summit keynote, Microsoft’s Bob Ward (Principal Architect) demonstrated a “diskless database” running on Hewlett-Packard...
2017-12-27
367 reads
Born SQL with Randolph West
Disable, don’t delete those indexes
A quick post this week, since it’s that time of the year when people do gift exchanges and put up...
2017-12-20
366 reads
2017-12-13
316 reads
All Mac users should do this immediately
This post is a public service announcement for all users of macOS High Sierra (10.13). (Note: Apple has already released...
2017-12-06
539 reads
Introducing SQL Operations Studio
Note: This is content that I originally wrote for our upcoming book, SQL Server 2017 Administration Inside Out, that did...
2017-11-29
697 reads
MySQL has this feature that SQL Server needs
In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because...
2017-11-22
340 reads
SQL Server 2017 Administration Inside Out
For the last five months or so, I have been helping some really smart people put words on paper, both...
2017-11-15
565 reads
T-SQL Tuesday: The Contributing Factor
Ewald Cress writes: Find a person or several people to pick on, and tell us a shareable story or two...
2017-11-14
321 reads
Is Transparent Data Encryption just security theatre?
I love theatre. In six months I am putting on two one-act plays for a local festival, because I don’t...
2017-11-08
327 reads
Gimmicks that work: XE Profiler in SQL Server Management Studio
I have a favourite new feature of SQL Server Management Studio 17.3 (SSMS), and that’s XE Profiler, which allows you to...
2017-11-01
488 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
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...
Database Archive missing FK
Bonjour à tous, je vais bientôt démarrer un projet d'archivage de données pour alléger...
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