Latest Blog Posts
I was excited to learn this week that I’ve been chosen as a participant in the Friends of Red Gate program for 2015. For those of you who are not SQL folk, you can stop reading now – Red Gate is a company who makes top-shelf products for working with… 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
- Building (for FREE) a Virtual Server for SQL Demos
- Cheating DBCC To Fix Index Corruption
- Don’t Get Slimed…
Read XML column attributes in to two columns DimType and Dimvalue from the below example also retrieve the data matching values[DimTypes (WIDTH or Height)].
<dimension name=”width” value=”12.77″/>
<dimension name=”height” value=”0.14″/>
<dimension name=”depth” value=”12.92″/>
Download SQL :- https://gallery.technet.microsoft.com/SQL-Querying-XML-f700bbb0
DECLARE @xml XML SELECT @xml = '<dimensions> <dimension…
While this is not a regular Excel tip, but it is about Excel. In my Excel BI Tips series, I am always looking for ways to build Excel dashboards or do BI work with Excel that will help everyone. In this case, I am going to discuss a new feature… Read more
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012. So far, we’ve covered:
- Tables and Schemas in the data warehouse
- Dimensions and Slowly Changing Dimensions
- Fact tables and measures
Steps to install standalone SQL Server 2012 instance
1) Start the setup > Go to Installation from Left > Click on 1st option of New SQL Server standalone edition from right
2) Click Ok to cont., In case of any failure, you need to fix that first
3) Enter Product… Read more
I’m very excited to offer a new course entitled “Advanced SSIS” in the Dallas area this spring. My friend and colleague Andy Leonard and I will be delivering this new 3-day course March 9-11, 2015 at the Microsoft offices in Irving, Texas. This course is intended for… Read more
Never really enjoyed reading through the statistics IO results, as it makes it hard to easily guage total impact when you have a long list of tables.
A friend referred me to: http://www.statisticsparser.com/
This site is great! However, I really don't like manually copying and pasting the results each time.… Read more
The VMware Users Group VMUG just announced a partnership with VMware, called the EVALExperience, to offer VMware technology pre-production 365-day licenses as part of the VMUG yearly subscription! It’s now included in the $200 annual VMUG Advantage Subscription fee! WOW!
Your tech lab can now include with the… Read more
Have you ever seen a constraint with a name like PK__TableNam__EA185FBF8FF1529D? It’s kind of funny looking right? I mean it makes no difference in terms of how things run but it does make it a bit of a pain when you need to code with it. Say dropping the… Read more
This Monday, at SQLSaturday Israel, I presented my new session, “The Data Loading Performance Presentation”.
I worked on the session a lot, and delivering it was tons of fun.
The session talks about the ways to load big amounts of data fast, and about the enemies that can make… Read more
By Steve Bolton
…………The Tietjen-Moore test may have the coolest-soundest name of any of the outlier detection methods I’ll be surveying haphazardly in this amateur series of mistutorials, yet it suffers from some debilitating limitations that may render it among the least useful for SQL Server DBAs. It is… Read more
One of the important task of any DBA is to find out all the jobs which are failed yesterday. Below SQL Script can be used to find out all the jobs which are failed yesterday.
CAST(CONVERT(datetime,CAST(run_date AS char(8)),101) AS char(11)) AS 'Failure Date',
SUBSTRING(T2.name,1,40) AS 'Job Name',
[name] as Tablename
sys.tables where cast(create_date as…
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to… Read more
;WITH DBSize (SqlServerInstanceName, DatabaseName, DatabaseSize, DBLogSize, TotalDBSize)
SELECT @@SERVERNAME SqlServerInstanceName,
As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in physical memory, preventing the Windows operating system from paging out a significant amount of data from physical memory to virtual memory on disk. This Windows policy is disabled… Read more