Blogs Phil Factor in Blogs Using Stored Procedures in SQL Server that return several results. Stored Procedures give you more freedom than functions, and so they would be the obvious way of developing processes in... 07 March 2018 3 min read
Blogs Krutesh Amin in Blogs Microsoft Dynamics 365 Storage Pitfalls – Here is the Cost Effective Solution In Microsoft Dynamics 365, by default, database is optimized for database record storage and not for files or attachment storage.... 03 March 2018 10 min read
Blogs Ben Emmett in Blogs My First Experience Migrating a .NET App to Core I recently migrated an old .NET Framework 4.5.2 app to .NET Core 2.0. This isn’t a guide to that process... 26 February 2018 9 min read
Blogs Louis Davidson in Blogs Music City Data – A Conference for Data Professionals Update: the schedule is out there, and as we promised, the topics are diverse. http://www.musiccitycode.com/sessions/ The conference starts in just two weeks... 14 February 2018 3 min read
Blogs Louis Davidson in Blogs Outputting Status In Your T-SQL Code The versatility of T-SQL allows you to create complex scripts to accomplish just about anything you need to do. In... 09 February 2018 5 min read
Blogs Louis Davidson in Blogs Matters of Timing in Concurrency There are a few topics in SQL Server that I love academically, but are truly a pain to get right.... 31 January 2018 5 min read
Blogs Louis Davidson in Blogs What Counts For A DBA – Adequacy “Aim High!” “You could be president some day!” “You’re just as smart as that Einstein kid down the street” …... 26 January 2018 3 min read
Blogs Louis Davidson in Blogs Inline Index Definition There are a lot of features of SQL Server that I (and I know some of you), never really get... 18 January 2018 3 min read
Blogs Rodney Landrum in Blogs Ready Player Tattoo I am sitting in my hotel room in Nashville getting ready for #SQLSatNash as I write this. I know there... 17 January 2018 7 min read
Louis Davidson New Beginnings for an Old Blogger The pain of parting is nothing to the joy of meeting again. – Charles Dickens Happy New Year! I am... 08 January 2018 3 min read
Blogs John Paul Cook in Blogs Simulating Bad Networks to Test SQL Server Replication SQL Server replication works well on a low latency, high bandwidth network. When actual networks have high latency or limited... 02 January 2018 8 min read
Blogs Phil Factor in Blogs Pivot Rotation and Matrix Transpose in SQL Server: A New Method? The question often comes up: how do you pivot data in SQL Server? In looking closer at the question, there... 12 December 2017 7 min read
Blogs John Paul Cook in Blogs Troubleshooting Failed PolyBase Installation in SQL Server 2017 This article shows you how to troubleshoot a failed installation of SQL Server and how to implement a workaround to... 12 December 2017 4 min read
Blogs Dennes Torres in Blogs Easy way to create policies using SSMS SSMS has an interesting feature that turns easy the creation of policies to check our servers compliance. Right-clicking an item... 09 October 2017 2 min read
Blogs Dennes Torres in Blogs Monitoring SQL Server with Power BI Query Store is becoming more and more important for server monitoring, specially in SQL Server 2017, which allows us to... 04 October 2017 2 min read
Blogs Phil Factor in Blogs Consuming hierarchical JSON documents in SQL Server using OpenJSON Over the years, Phil was struck by the problems of reading and writing JSON documents with SQL Server, and wrote... 12 September 2017 13 min read
Dennes Torres How much should you worry about CXPACKET? Several experts already wrote about CXPACKET before, there are plenty of articles about this subject on the internet, so, why... 11 September 2017 3 min read
Dennes Torres Thoughts about submitting a new Power BI Quick Measure ‘Quick Measures’ is a feature included in Power BI Desktop April update. It’s still in preview, so you need to... 25 August 2017 5 min read
Blogs Dennes Torres in Blogs Monitoring UnmatchedIndexes Warning If you are using filtered indexes in SQL Server, it worthwhile monitoring the UnmatchedIndexes warning, it can give us very... 07 August 2017 4 min read
Blogs Phil Factor in Blogs Statistics in SQL: Student’s t-test Many undergraduates have misunderstood the name 'Students' in the t-test to imply that it was designed as a simple test... 03 August 2017 5 min read
