Getting Started with CQRS – Part 2
In this second article of the series, Diogo Souza walks you through creating the MongoDB code, the query side of the pattern, to complete the CQRS configuration.
SQL SERVER – Always On Availability Group Listener Missing in SSMS but Working Fine in Failover Cluster Manager
I have helped many customers to solve complex issues in their environment by Comprehensive Database Performance Health Check. Sometimes, the issue looks very complex but once the solution is found it seems very easy. In this blog, we would learn about …
Tuning Dynamic SQL by Hand with Short Circuits
When we think about building dynamic SQL, we usually think about a stored procedure like this that takes input parameters, builds a string, and then executes that string. Here’s a simple example:CREATE OR ALTER PROC dbo.usp_SearchUsers @SearchDis …
New Fundamentals of Index Tuning Course
You’re a developer who needs to make your application go faster, and you don’t want to (or can’t!) change the queries. You’ve never been to an official training class, and your manager isn’t about to spring for travel. In …
SQL Server Reporting Services Report Builder with DAX Query Support
In this tip we look at how you can use DAX formulas within your SQL Server Reporting Services Report Builder reports.
SQL SERVER – Identify Datatype Using SQL_VARIANT_PROPERTY Function
One of my client of Comprehensive Database Performance Health Check sent me the following email about SQL_VARIANT_PROPERTY Function. I really love my job as SQL Server consultant as I get to learn most of the new stuff or discover the hidden knowl …
Free Downloads for Powerful SQL Server Management
You’re responsible for managing and troubleshooting SQL Server. Good news: you’re not alone. The SQL Server community has banded together and built a bunch of cool stuff to help you do your job easier. In a one-hour session this morning for …
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 …