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

Latest Blog Posts

Targeted Plan Cache Removal

A lot of times you’ll hear how people are experiencing sudden, intermittent, poor performance on a query, bad parameter sniffing at work, so they’ll fix it by running the following code:

DBCC FREEPROCCACHE();

BOOM!

Yeah, you just nuked the cache on your server because you wanted to take out a… Read more

4 comments, 102 reads

Posted in The Scary DBA on 24 August 2015

The tail of the log

The tail of the log

A little while back I was feeling overwhelmed by the number of blog posts ideas that I had so I asked around if anyone wanted one. Surprisingly I only had one taker. Warwick Rudd (b/t), and he wrote this great post… Read more

0 comments, 123 reads

Posted in SQLStudies on 24 August 2015

Above All, Good Judgment

What is permissible is not always honorable. – Marcus Tullius Cicero

Rules. Best practices. Guidelines. Design patterns. Policies. All are good and necessary, and you’ll rarely find anyone who will argue against the need to establish boundaries and set expectations. But can adherence to rules and design patterns be taken… Read more

0 comments, 99 reads

Posted in Tim Mitchell on 24 August 2015

Actual Emails: Allow NUNS to Lead You to Good Clustered Index Design

Wrote this email exchange with a colleague who wanted to confirm that the client-proposed design for a table was... less than optimal.


Subject: clustered index
From: A. Developer

Hey William,
I believe the client created this Clustered Index... <horrifying screenshot of a clustered index with many large nvarchar columns as…

Read more

0 comments, 118 reads

Posted in SQL Tact on 23 August 2015

WWH in SSIS ? Zero to Hero in SSIS series TIP#111

Dear Friends,

As shared in last post Post #110, We are starting SSIS tutorial series ( A Step by Step  SSIS learning tutorial) from today.

Before starting anything we might have some questions like What is SSIS ? Why SSIS ? & How to use SSIS ?

In general… Read more

1 comments, 129 reads

Posted in Rajat Jaiswal-337252 on 22 August 2015

016 – Me, Myself and I - WaterOx Consulting

Reading Time: 2 minutes

Me, Myself and I In WOxPod!, episode # 016 – “Me, Myself...

The post 016 – Me, Myself and I appeared first on WaterOx Consulting.

Read more

0 comments, 217 reads

Posted in WaterOx SQL on 21 August 2015

Versions (Master Data Services) - Where to use


Multiple versions of the master data within a model can be created in Master Data Services(MDS). When you create a model for the first time, Master Data Services (MDS) creates a default initial version of the model data.

While working with MDS, I was trying to find when to use…

Read more

0 comments, 92 reads

Posted in SQL & BI on 21 August 2015

Designing a Data Warehouse from the Ground Up Webinar Recording with Q & A

 Thank you to everyone that registered and attended my webinar Designing your Data Warehouse from the Ground Up webinar this past Tuesday. And I’d also like to give a special thanks to my good friend, Mitchell Pearson (b|t), for helping me present this webinar. We had… Read more

0 comments, 145 reads

Posted in SQL with Dustin Ryan on 21 August 2015

Your Devs' Questions Answered With sys.dm_server_services

It starts with "I'm a developer...

"... with no RDP access, how can I tell if the SQL Server Agent service is running?"
"... and I don't think CDC is working. Is the SQL Agent on?"
"... how can I tell how long has the SQL Server been running? Did…

Read more

1 comments, 141 reads

Posted in SQL Tact on 20 August 2015

ISNULL around the predicate and SARGability

You may have heard of the word, SARGable. In brief, it’s a term derived from the phrase, Search ARGument able, and relates to SQL Server’s ability to seek through an index for a predicate. Non-sargable predicates could lead to poor query performance which is why it’s important to understand this.… Read more

1 comments, 74 reads

Posted in SQLYSE with Pankaj Manek on 20 August 2015

Importing Power Pivot & Power View into Power BI

The Power BI August update just rolled out today (8/20/2015) and in the latest update there’s a lot of cool, new enhancements such as writing custom MDX or DAX queries to access your SSAS data sources, connectors for Azure HDInsight Spark and Azure SQL Data Warehouse (so awesome!), some various… Read more

0 comments, 219 reads

Posted in SQL with Dustin Ryan on 20 August 2015

Changing Cell Phones Again

Slightly off topic, but since I use a cell phone so much for data transfer and work, it’s important that my device works for me. This is my current thought and experience, so take it with a grain of salt.

I want to talk about my experience with Verizon and… Read more

0 comments, 239 reads

Posted in The Voice of the DBA on 20 August 2015

Reblog: How I prepared myself for the MCSE certification

SQLKover update: this was one of the most popular posts on my old blog. It’s quite old now and SQL 2014 content has been added to some of the exams. Nonetheless, a lot of it is still valid today.

Last week (this is a repost, so not actually last… Read more

0 comments, 211 reads

Posted in Koen Verbeeck on 20 August 2015

Remember Nepal - Lead by Example

Below is the original article in its entirety, that was published on the Americas MVP Community Facebook page, on July 18th, with respect to SQLCommunity and the Nepal earthquakes back in April/May 2015.

My recent communications with Shree Khanal, Founder & Leader Himalayan SQL Server User Group   and his… Read more

0 comments, 228 reads

Posted in Pearl Knows on 20 August 2015

Creating an SQL Databases – New Portal

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I was looking to do some testing recently, but needed a v12 SQL Azure database. The test system that I have in Azure is v11, and I needed… Read more

1 comments, 212 reads

Posted in The Voice of the DBA on 19 August 2015

Tables, Columns and Defaults Oh My!

Picture this if you could. You inherit a new database either through the change of a job, or finding a black box database server, or maybe due to the acquisition of a new application.

No matter the cause, you are now responsible for maintaining that database and you also really… Read more

0 comments, 153 reads

Posted in SQL RNNR on 19 August 2015

Power BI Tip: Use a Scatter Chart to Create a Calendar Report

The Scatter Chart in Power BI and Excel is very useful chart for visualizing three different metrics in tandem. But with a little bit of work you can use a Scatter Chart to create a Calendar chart for visualizing your metrics across the days of an individual month.

New to…

Read more

2 comments, 1,339 reads

Posted in SQL with Dustin Ryan on 19 August 2015

Time to Change

I recently spent two days consulting with a company on their database development and deployment processes. They are a small, capable, team of developers, database developers and a DBA who have embraced the idea that they need to be able to automate their deployments. I wasn’t in there to teach… Read more

1 comments, 168 reads

Posted in The Scary DBA on 19 August 2015

Getting Started With Power BI Desktop: Getting Data

Now that the Power BI Desktop is installed, let’s get some data. As of this writing, Power BI can get data from 37 different data sources and data connections – File (Excel, CSV, XML, Text), Database (SQL Server, Oracle, IBM DB2, MySQL, PostgreSQL, Terada, etc.), Azure (SQL Database, Azure… Read more

1 comments, 162 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 19 August 2015

SSMS’s Clipboard Manager

The other day Richie Rump (b/t) mentioned something called a clipboard manager on twitter. I’ll admit I had to ask what exactly they meant, but once it was described to me I realized it was something I’d wanted off and on for years. Basically it’s… Read more

10 comments, 1,309 reads

Posted in SQLStudies on 19 August 2015

Newer posts

Older posts