When disks have different sector sizes for primary and secondary replica log files in an AlwaysOn Availability Group Config
Recently I was analyzing a stress test result for an AG configuration, and as usual I was reading to SQL error logs to see if there is anything out of normal happened during the stress window.
In one of the asynchronous replicas, I started noticing a series of messages related… Read more
SQL Server 2016 AlwaysOn AG got many improvements, and I’m pretty impressed with the log throughput improvements and redo improvements based on some of my test cases(A detailed blog post on that will follow soon). In this blog post we will look at another key improvement, ie Database Level Health… Read more
SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide upgrade of SQL Server. Are you thinking of upgrading to SQL Server 2014? If yes, then wait! SQL Server 2016 is packed with great features and mainly, there is plenty… Read more
A strange error struck me last week, and this post is all about that.
What you normally expect when you run SELECT * FROM sys.messages? The query will return a row for each message_id or language_id of the error messages in the system, for both system-defined and user-defined messages. Read more
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable.
The transport security involves encryption of packets exchanged between the servers involved, and for AlwaysOn AG the encryption is made possible on the Hadr_endpoint.
By default, its encrypted using AES Read more
There are some improvements in the setup UI for SQL Server 2016 CTP3, and its great to see Microsoft making these changes as they receive feedback from multiple customers and early adopters.
My earlier post on setup UI changes for CTP 2 is available here.
The 1st change is… Read more
I’m starting a new blog series on Microsoft Azure Virtual Machines, and my goal is to write blog posts exclusively on Azure VM/SQL Server related topics.Here is the 1st post –
“Changing the size of a VM”
When creating an Azure VM to host your SQL Server, you have an… Read more
Recently I had to develop some SSRS report, and my desktop machine had SQL Server 2014 installed on it. I had previously used SQL Server Data Tools, and I tried to search for it under Programs. To my surprise, it was missing.
I thought I might have missed adding it… Read more
I keep getting questions around what core features are missing in Standard Edition of SQL Server,and why there is a need to install Enterprise edition for business critical systems.Here are my top features which are missing in standard edition –
Memory – Standard only supports 128 GB memory. Read more
SQL Server 2016 CTP2 public build was released by Microsoft yesterday, and if you haven’t downloaded it yet, then drop everything(No, not a Production DB !) and go and get it from here.
This post is based on the UI changes/additions which I observed while I installed this specific… Read more
Recently one of my developers brought this specific problem to my attention. He was trying to create a natively compiled stored procedure(With Execute as Owner), and was getting an error –
Could not obtain information about Windows NT group/user ‘Domain\UserName’, error code 0x5.
My first reaction was to… Read more
Last week during Ignite, Microsoft CEO Satya Nadella announced the next version(Till then it was called as SQL vNext) of SQL Server, and its SQL Server 2016.
Satya started the Ignite keynote, and he looked really pumped when he announced SQL 2016.
“SQL 2016 perhaps is the biggest breakthrough…
This is one of those posts which is due for a long time. I was really excited when Microsoft announced the release of an AlwaysOn AG template for the Azure Portal back in August 2014.
I had decided to explore this AG template soon after the launch, and this post… Read more
I keep getting questions on what is improved other than the increased number of secondaries(8 now) with AlwaysOn Availability Group(AG) in SQL 2014. In this blog post I would like to talk about one major enhancement around the increased readable secondaries availability in SQL Server 2014.
In SQL Server 2012… Read more
SQL Server 2014 is a great release with high performance features like In Memory OLTP, Updatable Column Store Indexes etc.
These features still remains as the top favorite and the most compelling reasons for organizations to do an upgrade, However SQL Server 2014 also includes very small but very relevant… Read more
Let’s talk about something simple today. You might already be knowing this, but if you haven’t seen/noted this before then this post will definitely help you.
I was working on requirement wherein I had to simulate a workload which will do massive inserts to a table which had computed column.… Read more
This was one of those days I was waiting to happen. You might be wondering whats special? Yes, this day is very special because Rimma Nehme will be giving a keynote on Cloud Databases 101.
PASS President Thomas LaRock kicked off the summit keynote.
Tom talked about the history of PASS and its growth curve. Positive numbers all over the place !
One of the key things to note is that PASS has delivered 1.3 million hours… Read more
I attended my 1st #SQLinthecity event hosted by RedGate yesterday. This is one of those events which I wanted to attend for a long time, and I’m glad I could make it this year.
This whole day event was packed with some cool sessions, and… Read more
November is not the right time to visit Seattle (Blame the rain!), but I kinda like November because that’s when #SQLPASS Summit happens.
SQLPASS Summit is the largest SQLServer conference in the world, and this year the number seems pretty huge with over 5000 attendees !
#Summit14 will be my… Read more