Creating and using inline table-valued functions
Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000. iTVFs remain a very useful tool in our SQL armoury, so let’s quickly revisit them and the different ways we …
Customizing the Default Azure Data Studio Dashboards
Explore the Azure Data Studio dashboards and see how to customize one of these dashboards to include a new widget.
SharePlex – Efficient and High Performance Replication from Oracle to Kafka
Ask any DBA what is their dream infrastructure and I promise you that they will narrate immediately a story which will be centered around no downtime and amazing performance. However, when you ask them if they know what exactly will make them …
The BI Journey: The Analyst
AdventureWorks, the famous bicycle and accessories seller, has hired a new intern who joined the North American regional sales department. Ruthie, who is studying for a degree in IT, landed the internship to work for the Sales Manager Stephen as an ana …
Implementing DevOps Doesn’t Get Rid of Database Administrators
I hear from a lot of database administrators who are worried about being automated out of a job. These kinds of worries are not new. Over the course of my career, I’ve seen CTOs outsource large groups of IT jobs to different regions around the wo …
Which Version of SQL Server Should You Use?
Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version? I know, management wants you to stay on an older build, and the vendor says they’ll only support older versions, but now’s your chanc …
The 4 capabilities you need to introduce true database DevOps
The latest Accelerate State of DevOps Report from DORA concludes that successful software delivery unlocks competitive advantages, including “increased profitability, productivity, market share, customer satisfaction and the ability to achieve or …
SQL SERVER – FCB::Open Failed – TEMPDB Files Fail to be Created with Error: “CREATE FILE Encountered Operating System Error 3”
Once there was an urgent request from my client and they asked my assistance. Without wasting any time, I sent them GoToMeeting invite and started working. In this blog we would learn how to fix FCB:: Open failed for TempDB database. As soon as I joine …
Does NOLOCK Really Applies No Lock? – Interview Question of the Week #209
Question: Does NOLOCK Really Applies No Lock? Answer: The answer is NOLOCK do apply the lock and it is Sch-S lock. Sch-S stands for Schema Stability. Quite a few people say it is actually Schema Shared lock and it is not correct. Sch-S or Schema Stabil …
SQL Server Data Migration: Tools and Services
The Database Migration Team of the SQL Server Product Group has created the following tools and services to facilitate migration between different versions of SQL Server or between on-premises and SQL Azure DB in the cloud (but not only)! Azure Da …
Why Attend 21 Essential Scripts: Performance Tuning for EVERYONE?
After sending out the previous email where I explained that anyone who will attend SQLBits 2019: Pre-Con – 21 Essential Scripts: Performance Tuning for EVERYONE, will get 1 Hour FREE Consulting Hour, it seems that many of you have signe …
Wanna see Erik Darling as Freddie Mercury at #SQLbits?
Erik Darling is raising money for the Mercury Phoenix Trust, fighting AIDS worldwide to help save lives. If we raise $5,000, he’ll present his SQLbits indexing session dressed like Freddie Mercury: If I hit my goal on this, I’m gonna deliver my @ …
Win Apple Watch Series 4 and Solve SQL Server Performance Problems
Ask any DBA what would they love to monitor in their SQL Server and I promise you that you will get quite many different answers to this question. Though every DBA would love to see their server always up upon asked what exactly they would like to watc …
Logging SQL and Change-Tracking Events in EF Core
Julie Lerman introduces you to the new logging APIs in .NET Core, concentrating on SQL and change-tracking events, with a focus on providers that output to the console and the debugger.
Manipulating Filetable Files Programatically
Learn how you can work with FileTable files from T-SQL as an alternative to the drag and drop methods of using Windows Explorer