Latest Blog Posts
It is a “common knowledge” among SQL practitioners that VIEWs don’t perform well. Recently during an application’s development I put this to the test. I needed to construct a VIEW for a report the system was producing. It was highly complex. Let’s take a look at the general structure of… Read more
In last post TIP #91 we talked about What is Data compression ? What are the features ? Now in this tip we will take implement the data compression with basic steps.
So lets follow the steps
1) Right click on the table on which you need… Read more
declare @table table ( [Paid Date] date ) insert into @table values('20150102'),('20150512'),('20150830'),('20151231'),('20141230') ;WITH Quarters AS ( SELECT Q = 'Q1', MonthBegin = 1, MonthEnd = 3 UNION SELECT Q = 'Q2', MonthBegin = 4, MonthEnd = 6 UNION SELECT Q = 'Q3', MonthBegin = 7, MonthEnd = 9 UNION SELECT…
There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions, my script for finding where backups are taken, Paul Brewer’s sp_RestoreGene to name a few. It gets tiresome at best to constantly be looking… Read more
In a recent article on SSG, I discussed how to use Extended Events to function in a Profiler like fashion. You can read about that here. I recommend reading that article first because it helps to lay some of the groundwork for this article.
Within Management Studio, from a… Read more
Last week I attended SQLRally Nordic 2015 in Copenhagen. SQLRally is a regional conference organized by PASS, kind of a mini PASS Summit, if you like. The event last week was 3 days long, and it was the biggest ever – close to 600 people.
I had a great… Read more
Who will guard the guards themselves? – Latin
Let’s talk a little about how data is most commonly leaked from a database.
Now to be really frank and honest, there is not much we can really do about loss of… Read more
What is the Azure Data Factory?
The Azure Data Factory is a managed service for data storage and processing. It allows you to build cloud based solutions to move and store your data in a centralized managed environment. Source data can be pulled from on premise or cloud environments consisting… Read more
When Fusion IO burst onto the scene in 2007, offering a PCIe card that was said to be able to achieve 100,000 IOPS, the IT world went wild. While Fusion IO certainly is a pioneer in the PCIe SSD space, this technology has come a long way in its short… Read more
I get around quite a bit.
Next week I’ll be visiting three cities in Germany talking to user groups in Frankfurt, Cologne and Munich on the 17th, 18th, and 19th of March, respectively. Here’s the one link I can find for information. EDIT: Here’s Cologne and here’s Munich.
Next,… 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
A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else is in the database and you need to find them and kick them out before you can proceed. Historically I would use sp_who and scroll down the list looking for… Read more
VM snapshots are one of the best virtualization features ever. But…have you ever had a VMware vSphere or Hyper-V snapshot grow out of control and fill the datastore the VM resides on? You know what happens… even the best VM admins out there seem to get burned once when they… Read more
It’s not usual for development projects to undergo an architecture review, but too many times these reviews consist only of developers. There are no server or network folks, much less any DBAs or security personnel. When I’ve brought this up to some of my developer friends, they wonder what the… Read more
A part from performance many times we faced challenges related to space of our database. Sometimes our database is actually taking huge space and sometimes it our mistake due to which it took space.
It is worst condition when you are on a dedicated hosting or cloud hosting with limited… 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
- Cheating DBCC To Fix Index Corruption
- Do You Need A Log Recovery Tool?
- Building (for FREE) a Virtual…