Easily Shred Event Data
Parsing XML is the epitome of salt in a wound for a DBA. Parsing the XML from Extended Events need not be so painful. Read further to discover how...
2016-08-01
29 reads
Blog Posts
Index-Cheat-Sheet. The complete Index-compatibility Matrix for SQL Server
(DE)
Mit dem Aufkommen der Columnstore Technologie und auch der In-Memory Technologie in SQL Server 2014 sind insgesamt 4 neue...
2016-08-01
672 reads
Index-Cheat-Sheet. The complete Index-compatibility Matrix for SQL Server
(DE) Mit dem Aufkommen der Columnstore Technologie und auch der In-Memory Technologie in SQL Server 2014 sind insgesamt 4 neue Indextypen zu den althergebrachten page-basierten hinzugekommen.
Wo es früher nur...
2016-08-01
9 reads
Monday Morning SQL Break – August 1, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to...
2016-08-01
8 reads
Monday Morning SQL Break – August 1, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...
2016-08-01
877 reads
Power BI Custom Visuals Class (Module 10 – Card with States)
In this module you will learn how to use the Card with States Power BI Custom Visual. The Card with...
2016-08-01
1,213 reads
SQL Server Indexing Book Giveaway – Part 7
More of the same with the next Expert Performance Indexing for SQL Server book giveaway. So far, I’ve sent out six copies of the book based on comments from the past six (1, 2,...
2016-08-01
16 reads
SQL Server Indexing Book Giveaway – Part 7
More of the same with the next Expert Performance Indexing for SQL Server book giveaway. So far, I’ve sent out six copies of...
2016-08-01
808 reads
There Is No Difference Between Table Variables, Temporary Tables and Common Table Expressions
I actually saw the above statement posted online. The person making the claim further stated that choosing between these three constructs was “personal...
2016-08-01
1,387 reads
Top 3 books for Becoming TOGAF Certified
I often get asked what books are useful for preparing for the TOGAF certification exam. The resources are generally from...
2016-08-01
977 reads
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers