Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Lessons Learned from a Poor-performing VIEW

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

4 comments, 7,029 reads

Posted in DwainCSQL on 12 March 2015

Data Compression–A unique feature PART–II TIP #92

 

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

1 comments, 118 reads

Posted in Rajat Jaiswal-337252 on 11 March 2015

T-SQL – How to get the Financial Quarter details of a date field

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…

Read more

4 comments, 5,046 reads

Posted in PowerSQL By Prashanth Jayaram on 11 March 2015

Using Solutions in SSMS

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

3 comments, 217 reads

Posted in SQLStudies on 11 March 2015

Audit Schema Change Report

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

4 comments, 4,454 reads

Posted in SQL RNNR on 11 March 2015

SQLRally Nordic 2015

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

0 comments, 208 reads

Posted in Guy Glantser on 10 March 2015

Can an EKM Save The World of Data?

Reading Time: 4 minutes

Quis custodiet ipsos custodes?

Who will guard the guards themselves? – Latin

Let’s talk a little about how data is most commonly leaked from a database.

The user.

Now to be really frank and honest, there is not much we can really do about loss of… Read more

1 comments, 5,395 reads

Posted in WaterOx SQL on 10 March 2015

Azure Data Factory

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

0 comments, 107 reads

Posted in Business Intelligence and Enterprise Architecture on 10 March 2015

Making Sense of PCIe SSD Use with SQL Server

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

0 comments, 3,726 reads

Posted in Adam Kreul | Blog on 10 March 2015

SQL Nexus Might Just Save Your Bacon

The year is 2015, and I’m still surprised by how many people have never heard of SQL Nexus; although it has been available since approximately 2008. SQL Nexus is a tool that that is designed to collect and analyze data to help you troubleshoot SQL Server performance issues. There are…

Read more

0 comments, 172 reads

Posted in Everyday SQL on 10 March 2015

A Comprehensive Manual to Manage SQL Server Database

SQL Server is a uniquely designed Relational Database Management System developed by Microsoft. Its basic functionalities include storing, manipulating and retrieving data requested by multiple software applications running on a single computer or on any other machine across a network.

Details of SQL Server Database:

For storing SQL Server…

Read more

0 comments, 145 reads

Posted in Rajat Jaiswal-337252 on 9 March 2015

ICYMI: Troubleshooting Availability Groups and the Schema Switcharoo – SQL Server Performance

Aaron Bertrand (b | t) is on a roll this month’s SQL Server performance highlights with more great articles from SQLPerformance.com.

 

Troubleshooting AlwaysOn – Sometimes it takes many sets of eyes

Aaron Bertrand (b | t) hit some obstacles recently when configuring an Availability… Read more

2 comments, 108 reads

Posted in Kevin E. Kline on 9 March 2015

Upcoming Events Where We Can Chat

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

0 comments, 95 reads

Posted in The Scary DBA on 9 March 2015

Exam Prep 70-463: Logging in SSIS 2012

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:

Read more

0 comments, 719 reads

Posted in Cleveland DBA on 9 March 2015

Who’s using that database?

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

0 comments, 5,774 reads

Posted in SQLStudies on 9 March 2015

Keep VM snapshot growth from wrecking your day

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

0 comments, 4,104 reads

Posted in Technobabble by Klee from @kleegeek on 9 March 2015

Why You Shouldn’t Skip the Infrastructure/Security Architecture Review

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

0 comments, 4,592 reads

Posted in Databases – Infrastructure – Security on 9 March 2015

SQL Saturday Oklahoma City, OK: 422 August 29th, 2015!

We're proud to bring back the OKC SQL Saturday for the 5th year in a row! We have 3 precons setup and ready to cover almost any interest! You can find more information about them here.

We're hoping to see new speakers this year! 

We will still have our…

Read more

0 comments, 88 reads

Posted in DBA On The Go on 9 March 2015

Data Compression– a unique feature of SQL Server TIP #91

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

0 comments, 135 reads

Posted in Rajat Jaiswal-337252 on 8 March 2015

Friday Followup For March 6, 2015

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…

Read more

0 comments, 119 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 6 March 2015

Newer posts

Older posts