How to Become a SQL Server Database Administrator
This whitepaper provides insights on required skills and how to acquire those skills in order to become a SQL server database administrator. read more
Temporal Tables – Part 6 – Start and End Times in UTC Time Zone
In my first 5 blogs on Temporal , I failed to note something pretty important about their usage. The start and end times for the row (and it follows, the historical rows) are likely not in your local time zone. They are stored in UTC time zone. This is …
SQL SERVER – The Cluster Resource ‘SQL Server’ Could Not be Brought Online Due to an Error Bringing the Dependency Resource
In my lab setup, I already have a 2 node windows 2012 R2 cluster. I already had one SQL server 2012 instance is working fine without issues. However, when I was trying to install a new additional SQL 2012 instance, the installation reached till the las …
What’s new in Entity Framework Core 2.0?
In just a couple of week the PASS Application Development Virtual Group will host a new webinar, this time with Chris Woodruff who will talk about new stuff in EF Core 2.0: What’s new in Entity Framework Core 2.0? Entity Framework (EF) Core is the ligh …
How to Create Temp Table From Stored Procedure? – Interview Question of the Week #139
Question: How to Create Temp Table From Stored Procedure? Answer: Some questions never get old. This is one such question, which I keep on hearing for many years and I hear it often. I often get asked this question in my Comprehensive Databas …
SQL SERVER – How to Move SQL Server Cluster to Different Domain?
One of my blog readers sent an email where he wanted my quick opinion about SQL Server cluster. Hi, We are having SQL Server 2014 clustered instance running on top of Windows Server 2012. As a part of the acquisition, we need to move the domain servers …
SQLskills SQL101: Azure SQL Database Monitoring
As Kimberly blogged about earlier this year, SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologies used the wrong way, or …
How Much Can One Row Change A Query Plan? Part 2
Earlier this week, I showed you two nearly identical queries and their estimated plans: One of these things is much like the other They look pretty darned identical – so how much worse can one query be? Here’s how much worse: Top 100: 51.0 …
SQL SERVER – AlwaysOn Availability Group Listener – This TCP Port is Already in Use
While doing a preparation of a demo, I encountered below error while creating the listener of the AlwaysOn availability group. I was trying this from Management Studio. Here is the text of the error message. The configuration changes to the availabilit …
Three new sessions in three months
Waking up from my blog-hibernation at this time is probably not ideal. I should spend my time on other things. For instance, on creating slide decks and demo code for the three completely new sessions that I will be delivering at various conferences wi …
The Quick and the Dead Slow: Importing CSV Files into Azure Data Warehouse
The series so far: Creating a Custom .NET Activity Pipeline for Azure Data Factory Using the Copy Wizard for the Azure Data Factory The Quick and the Dead Slow: Importing CSV Files into Azure Data Warehouse In my previous article, I described a way to …
Optional Parameters and Missing Index Requests
That’s when it all gets blown away At one point or another in everyone’s SQL-querying career, they end up writing a query that goes something like this: SELECT something FROM stuff WHERE (@thing1 is NULL or whatever = @thing1) AND … These …
Extending DevOps practices to SQL Server databases with ReadyRoll from Redgate
In this webinar, Microsoft MVP Steve Jones and Redgate’s Arneh Eskandari will show you how Redgate’s Database DevOps solution can work to improve your database development and deployment processes. You’ll see a demo of the following Redgate …
Automate MSBI deployments Using PowerShell
There are various ways we can deploy MSBI project deliverable. This article will give you an idea to automate MSBI deployments using Windows PowerShell. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk edito …
SQL SERVER – How to Reach Out to Cloud – Cloud Computing with PartitionDB
Cloud Computing is not new anymore; everyone is talking about the cloud. Has everyone already touched the sky? Apparently not. There are many organizations around that hesitate to make the move, or cannot because of compliance issue or other lim …