Scale-out SSRS (a brain dump)
So, I just got finished with a SQL Server Reporting Services (SSRS) scale-out deployment, based largely on this step-by-step guide. Things mostly went...
2018-02-06
399 reads
So, I just got finished with a SQL Server Reporting Services (SSRS) scale-out deployment, based largely on this step-by-step guide. Things mostly went...
2018-02-06
399 reads
So I’ve spoken to more than one DBA who is not familiar with using the command prompt (aka command line)...
2018-01-02
373 reads
I had yet another example of how beautiful Regular Expressions can be in SQL coding today, and so I thought...
2017-12-28
711 reads
Let's have a liltle fun with PowerShell. Along with, I suppose, a couple of useful things and links.
The post PowerShell...
2017-11-15
378 reads
Today I presented one of my favorite sessions - T-SQL's Hidden Support Feature - for the DBA Fundamentals group! They'll put up...
2017-11-14
347 reads
I don’t think everyone should be a technical speaker. But I wouldn’t object if everyone spent a season trying. Why be a...
2017-11-08
357 reads
I’m presenting T-SQL’s Hidden Support Feature for the DBA Fundamentals virtual chapter on Monday, Sep 11 at 9:30 PM CDT! Session description: The most effective...
2017-09-06
375 reads
Great. Now you can't even trust your phone's screen, of all things, to not steal your data… https://t.co/KUyGjwsih2 — Adam Machanic...
2017-08-29
389 reads
You're thinking of starting a blog, or teaching, or training videos. Will it pay off? Will it be worth it?...
2017-07-29
681 reads
Two years ago, we officially became MinionWare and launched the absolutely masterful SQL Server management solution, Minion Enterprise. For a...
2017-07-18
327 reads
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...
This comic was retweeted into my timeline on Twitter (I refuse to call it...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
Comments posted to this topic are about the item Creating a CSV Parser in...
Hello experts, We set up the Brent Ozar SQL Agent alerts, one of which...
Hi as you can see at https://www.sqlservercentral.com/forums/topic/test-sql-servers#post-4422832 we would really like multiple instances in...
I want to enable two trace flags, 4199 and 4137, for a single query. How should I do this:
-- A SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, 4137); -- B SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, QUERYTRACEON 4137); -- C SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199), (QUERYTRACEON 4137);See possible answers