Latest Blog Posts
As we know, when we create database on SQL Server instance, SQL Server engine sets the login that created the database as the default database owner. This gives the user full control on the database, meaning he/she can do whenever they like on that particular database. According to the SQL… Read more
TSQL: To find number of words in a given string
DECLARE @DemoTable Table
INSERT INTO @DemoTable (Col)VALUES ('JOHN M SMITH ABC COMPANY')
len(Col) - len(replace(col, ' ', '')) + 1 No_Of_Words
sp_spaceused is one of the system stored procedure used frequently by many DBA’s that reveals amount of space used by database/tables. This procedure can be executed either by passing parameters or no parameters. The objective of this stored procedure is to measure the…
Have you ever been really focused on solving a problem? So focused that you tuned out the rest of the world around you? A monkey clanging cymbals in the cube next to yours wouldn’t bother you, you are so focused. Some IT professionals call this “in the zone.”
Now,… Read more
Quick and simple for today. Happy Holidays to you!
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no such things as unicorns, so I can… Read more
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.
Posts That Were Popular This Week
- Little Java Boy
- The Value of Writing Good
- Building (for FREE) a Virtual Server for SQL Demos
SQL Server T-SQL coalesce simplifies the use of a case statement to find the first non-null value of your expression. For example, I want to return the products in the AdventureWorks sample database and show the SellEndDate if it exists or the SellStartDate if the SellEndDate is null. Read more
The 5th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 5 contains all the hotfixes released since the initial release of SQL Server 2014 RTM.
Those who are facing severe issues with their environment, they can plan to… Read more
Monitoring Geo-Replication in SQL Azure using DMV's
Azure SQL Database comes with a host of disaster recovery options. The most robust of these options involves replicating the database across different geographic regions using Geo-Replication. In this article, I'll discuss how you can monitor the state of Geo-Replication…
currently on version 14.60
I'm a big fan of finding tools that help automate and streamline things that should are routine actions.
Suprisingly, I've found it incredibly challenging to move away from the default Windows Explorer for file management, as the familarity it offers makes it somewhat tough to be… Read more
I didn't realize that the DAX OR function only accepts 2 arguments compared with the similar function in Excel where a limit of arguments is set to 255. This difference only occurred to me when I received an error in my PowerPivot data model with an attempt to list more than 2 arguments…
Just wanted to blog a quick update on SQLSaturday#380 in NYC, happening on May 30, 2015. As you are hanging the stockings by the chimney with care, we hope you register for NY SQLSaturday, and to see you there :-) The official announcement was made in my recent blog, SQLSaturday… Read more
A table with identity column have ‘n’ rows in that few rows are deleted. How to find which rows are deleted?
Download code :- MissingRows
create table MissingRowDemo (a int);
insert into MissingRowDemo values (7001);
insert into MissingRowDemo values (7002);
insert into MissingRowDemo values (7004);
Twas 2 days before Xmas & all through the office,
not a creature was stirring not even old Maurice.
With merriment going on outside of his window
There sat a bearded DBA without much to do
No changes can be made through the holiday season
We’re on skeleton support, which… Read more
As the door begins to knock I start to wonder who it can be. As I begin to open it the person on the other side asks if he can talk to Perfection. No, I replied, perfection isn’t here and will never be here.
That same concept is what this… Read more
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (
so exciting), follow me on twitter (@StrateSQL). And see these throughout the day as I tweet out links of things I find interesting. While these links aren’t the answer… Read more
It’s time to follow up with a discussion of Microsoft’s cloud-centric approach to big data using HDInsight.
MICROSOFT SQL SERVER AND BIG DATA IN THE CLOUD
HDInsight is a 100% Apache Hadoop service, currently at v2.2, available through Microsoft’s Windows Azure cloud offerings. HDInsight makes all of the standard… Read more
Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is looking for was “What is the use of RPC in cluster” ?
The Remote Procedure Call (RPC) [http://support.microsoft.com/kb/832017] system service is an interprocess communication (IPC) mechanism that enables data… Read more