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
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
This is more for my benefit in the future, but hopefully it can help someone else too. We recently had...
2017-10-25
4,189 reads
Recently, I was asked to assist an organization with getting their data back for a SQL Server that had experienced...
2017-10-18
619 reads
In the #sqlhelp Slack channel on the SQL Server Community Slack workspace last month, Jemma Hooper asked: When trying to...
2017-10-11
453 reads
For a few years now, Microsoft has augmented its irregular release of Service Packs with a more frequent Cumulative Update...
2017-10-04
439 reads
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to...
2017-09-27
540 reads
I’ve been working with SQL Server for many years now, and up until recently, I assumed that rebuilding any clustered...
2017-09-20
424 reads
Joe Obbish wrote an epic post a few weeks ago about loading a trillion rows into a non-partitioned table in...
2017-09-13
436 reads
I got a strange request in a Slack channel the other day. A colleague in South Africa, who uses Windows,...
2017-09-06
379 reads
Last week, I posted this statement on Twitter, along with a screen capture of the official Microsoft documentation: Reminder: Max...
2017-08-30
338 reads
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Comments posted to this topic are about the item Is Ransomware Fading?
Comments posted to this topic are about the item How to Resolve SQL Server...
Comments posted to this topic are about the item A Simple Choice
I have this data in a table?
CatIDCatName 3MonitorsWhat is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS cSee possible answers