Latest Blog Posts
Thank you Cathrine Wilhelmsen for hosting this week’s #tsql2sday.
If I knew that this T-SQL Tuesday was going to be about monitoring I would have saved my Monitoring SQL Agent Jobs post from last month. No worries though! I think I’ll talk more generally about monitoring.
If you don’t monitor…
Cloud Service ModelsThere are three main service models in the cloud. You will see these buzz words being used a lot in cloud discussions:
- IaaS - Infrastructure as a Service
- PaaS Platform as a Service
- SaaS Software as a Service
Last week, I took the 70-461: Querying Microsoft SQL Server 2012 exam. I decided recently to try and achieve getting my MCSE: Data Platform certification within the next six months. Taking this exam was step one, and now I have four remaining. Rather than spending a bunch of money on… Read more
A big thank you to Cathrine Wilhelmsen (blog | twitter) for hosting this month’s TSQL2sday party. Monitoring is this month’s topic and it’s a very important one. It could mean the difference between having a job and looking for a job.
When I started working with SQL Server… Read more
Alerts have been around for as long as I can remember, so some time before breakfast. That probably means you need to get a wriggle on and upgrade to SQL Server 2014. If you are still wondering whether to upgrade I did write a post on it some time back… Read more
Introduction to SQL server Objects
In databases, when we talk about database objects, it means we are talking about SQL Tables. SQL Tables are also known as SQL Objects which manages all the records in a specific order in SQL server database. The data, stored in a Table are managed… Read more
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. And if there are a lot of questions, you may… Read more
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more
I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:
Give me all the rows from this table and only those rows that match from the other table.
But, wouldn’t this logic work just as well:
Give me only the…
This is a basic introductory post about Microsoft’s new product: Azure DocumentDB, and how it compares to SQL Server.
What is DocumentDB?
Question : Database snapshot captures only data changes or it will also save real database from DDL changes (like table structure, store procedure etc.)
Answer : Yes.
So here we explian how :-
Databse snapshot is read only databse. It’s a static view database on which only read only operaton… Read more
Creating a primary key on a float data type can lead to what appear to be duplicate primary…
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…
There are two flavors of SQL Server in Azure: one is the traditional SQL Server platform hosted in Azure virtual machines, also described as Infrastructure as a Service (IaaS). The other is called Azure SQL Database, database-as-a-service or Platform as a Service (PaaS). there are several important differences in functionality… Read more
Only my second SQL Saturday of the year (wow), but SQL Saturday #393 is next week in Redmond, WA. This is my first time at a SQL Saturday in Washington, though I’ve been to the area many times. I’m looking forward to the trip up with a couple days in… Read more
A few weeks ago Bala Narasimhan from PernixData and I recorded a short conversation where we discussed the tips and tricks that both DBAs and Infrastructure Administrators need to maximize the performance of their systems without significant re-architecting of their environments. Check it out!
I got my annual two emails from the PASS organization with the notification to update my profile to vote. I’m not sure why I get two emails to two different email addresses when I’ve only logged into one profile account in the last six or seven years, but I’m sure… Read more
Bala Narasimhan, Vice President of Products from PernixData, and I recently sat down and discussed the convergence of infrastructure, SQL Server, virtualization, and storage systems. We chatted about some of the ongoing challenges of high performance virtualized SQL Servers and the impact they can have on the rest… Read more