Latest Blog Posts
I will be writing
this article in four parts because this topic is huge and amount of information
can be overwhelming for readers and for me also. So we will be exploring it
step by step.
When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that I noticed when you are connected to an Azure (logical) SQL Server.
So below I have 2 screen shots – 1 when connected to an “earthed” SQL Server versus the… Read more
It less than week to SQL Relay - a week long SQL conference that is visiting Birmingham, Cardiff, Reading, Nottingham and Leeds.
See if you can persuade your boss to let you out to receive some top notch training from industry experts and speakers.
David will be there speaking on…
In our last blog on Future DBA, we discussed on HADOOP -HDFS system. how as we know HDFS management is quite difficult so with the help of Vendors -Cloudera/Hortonworks/MapR we can integrate the tools/utility in a GUI way and can be … Continue reading
Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what happened. Can Query Store tell us?
My first blush response is, no. Not really. Query Store keeps aggregate performance metrics about the queries on the database where Query Store is… Read more
Everyone has goals or at least they should have goals. As a young professional out of college, I had plenty of goals, but none of them involved SQL Server. I really had no idea of where I wanted my career to go other than working in IT. Finally in 2000,…
Over the weekend, I went to the local theater to watch Sully, the movie about the US Airways pilot who successfully landed his A320 jet on an icy river after losing both engines shortly after takeoff. I enjoyed the movie for its main story line but also for some of… Read more
As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve been collecting a few links with examples and instructions I have been using to improve my skills.
Some awesome PPT slides by Edwin M Sarmiento (b/t).… Read more
In our last blog on Hadoop Big Data we have discussed about Hadoop and its tools/utility to connect to HDFS. on continue to that hadoop is mostly for big data and the on hadoop is stored in HDFS with named node … Continue reading
This has bit a couple of clients recently, figured I'd put out a PSA.
Express editions of SQL Server Reporting Service, from SQL 2016 on down, cannot connect to Azure SQL Databases. Turns out, getting something for free does
have some significant limitations.
For example, you'll see an error message…
This may feel very
simple to many developers and yes it is, but I saw this request somewhere in community
website.So thought of creating a very simple
Here I am using AdventureWorks2014 database, we have table [AdventureWorks2014].[HumanResources].[Employee]
and we will use [HireDate] column. I am adding two new columns…
This is a story of my 11-year association with PASS, and the many ways it helped me grow as a person and in my career. And the many ways I saw other people grow.
Summit #1 – 2006: Gaylord,TX: I was a visa holding dba-developer at a small shop.… Read more
With just 1 week until SQLSaturday Portugal Porto 2016, I am glad to share that we have SQLSaturday Lisbon 2017 already live! Between 9th and 11th of March 2017 at Microsoft Portugal in Lisbon, the 7th edition of the SQLSaturday…
Ok, so what is this 4 part naming convention? It is the way the SQL Server (and other DBs out there) identify the exact location of the objects in the environment. The 4 part name follows the convention of <server>.<database>.<schema>.<object>. In most cases, you are only going to use the…
I've been gone... wow. Since March 31st of this year?! Let's fix that.
So what has been holding me back?
Kids? I have three! 2, 15, 18. One wants to drive, one wants to move out into the world, the other wants to rule the world.
Wife? She's always there…
Its been another Learning Tree week for me this week and a very interesting one at that. I'm on the Learning Tree IAT...IAT stands for Instructor Advisory Team, the team consists of Learning Tree instructors and Learning Tree senior management and its purpose is to come up with ideas and…
Filtered index is a type of non clustered index introduced in Sql Server 2008. As the name suggest filtered index is an optimized non clustered index with a filter criteria. It uses filter criteria to index a portion of rows which qualifies for the given predicate. So in filtered index…
Last week, we faced a basic and yet the only major problem that sql developers/admin had to deal with and yes your guess is right, It was with SQL QUERY RUNNING SLOW. I will be explaining the problem below, however I want everyone reading this to help me find answers…
I was riding the elevator up from lunch today, at work. I am relatively new at my job and do not know several people at my workplace – yet. I live in a small town, and quite a lot of them know me as someone active in the local community.… Read more