SQL SERVER – Global Variable @@DEF_SORTORDER_ID – Old and May be Deprecated
I always blog about things which are new and updated but today we are going to write about something which is very old and it is near deprecated. We are going to about the global variable @@DEF_SORTORDER_ID. Let us see what it is and how it was used on …
Introduction to SQL Server Security — Part 5
The post Introduction to SQL Server Security — Part 5 appeared first on SQLServerCentral.
A Self-Serve System to Refresh Databases – Part 1
I am not sure I could count the number of times I have restored a backup from production to a test or dev server. It has happened enough times I finally wrote a system so the developers could do it themselves. This series of articles will review this s …
Pop Quiz: SQL 2000 Bug or SQL 2017 Bug?
2002: Me and Bailey, mom’s Great Dane When I was thinking about this site’s 17th birthday, I started wondering: back in 2002, what bug might I have been working with in SQL Server? I started reading back to the list of bugs fixed in SQL Ser …
Recorded Class Instant Learning – SQL Server Performance Tuning Practical Workshop
SQL Server Performance Tuning Practical Workshop is one of my most popular training. Every month I get tons of request to deliver this class but there is a limitation of how many classes, I can deliver in person. This class is built on my most po …
SQL Server Trigger on View Example
The post SQL Server Trigger on View Example appeared first on SQLServerCentral.
SQL in the City Summits – US & Down Under
The post SQL in the City Summits – US & Down Under appeared first on SQLServerCentral.
The Curious Case of… trying to find an MDF file in a RAW disk
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …
Oracle for Absolute Beginners: Problem-Solving as a New Developer
Hi. My name is David. If you’ve heard of me, there’s a good chance it’s from my Oracle for Absolute Beginners series which I write for Simple Talk. (Either that, or you got here from googling the famous NFL sportsman who has the …
Updated First Responder Kit and Consultant Toolkit for April 2019
This month, lots of improvements and bug fixes, including checking for paused resumable index operations, Evaluation Edition expiration dates, sp_BlitzCache shows the number of duplicated plans for each query, sp_BlitzIndex will skip a list of database …
What is Automation?
Today I got a bit closer to a meaningful definition of automation as it applies to the software development process. I’ve been turning this concept over in my head for a while, which is partly related to the dreaded question of licensing. Why sho …
DBA Fundamentals – 3 Performance Tuning Tricks you Always Wanted to Know
Today we will see a free online video which I did for DBA Fundamentals Virtual Chapters for PASS. The title of the video is 3 Performance Tuning Tricks you Always Wanted to Know.Here is the abstract of the same session:No one wants the slow performance …
Row Pattern Recognition in SQL
The post Row Pattern Recognition in SQL appeared first on SQLServerCentral.
Build an OLAP Cube in SSAS using an ADO.NET Data Provider
SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Service …
Glenn’s Tech Insights For April 29, 2019
(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …