SQL Server

SQL Server Community

SQL Server Blogs

Colleen Morrow
Follow /29 Jan 2015 at 3:00pm / SQL Server

Exam Prep 70-463: Data Flow Transformations

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...
30 0 /
Dinesh Asanka
Follow /29 Jan 2015 at 5:29am / SQL Server

SQL Server String Functions Cheat Sheet

SqlBak.com presents you a free SQL Server String Functions Cheat Sheet. http://sqlbak.com/blog/wp-content/uploads/2015/01/TSQL-STRING-FUNCTIONS-CHEAT-SHEET.pdf http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
51 0 /
Paul Turley
Follow /29 Jan 2015 at 2:42am / SQL Server

Power BI Workshop Videos

I’ve created a series of five tutorial videos for a set of workshops I’ll be doing at several events this year.  The workshop is available from an hour-long quick demo to a full-day, hands-on workshop with a hosted lab environment in the cloud. ...
41 0 /
Follow /28 Jan 2015 at 3:45pm / SQL Server

Join #TeamData for a Virtual Pi Day 5k

  Register You can join #TeamData on a virtual run or walk any time between 12-15 March. A virtual races means you run it wherever you want, whenever you want during those days.  You can even split your runs/walks over those days. HOW...
79 0 /
Derik Hammer
Follow /28 Jan 2015 at 2:00pm / SQL Server

Active sessions and block duration

As a DBA, we all need the ability to take a quick glance at the currently active processes on our servers. A lot of times we do this during a problem such as transaction blocking. The first tool that normally comes to mind for this type of investigation...
41 0 /
Kenneth Fisher
Follow /28 Jan 2015 at 1:00pm / SQL Server

A quick email interview of Pass President Thomas LaRock

Back in December I had the thought that it would be fun to do an email interview with someone. As I thought about it Thomas LaRock ( b / t ) sounded like a good choice since he has been working in the community for quite a while and is our current Pass...
44 0 /
Follow /28 Jan 2015 at 6:52am / SQL Server

Join #TeamData for the Portland Half Marathon

If you’ve been following me on Twitter ( @datachick ), you know I’ve been checking some races off my bucket list.  I apologize for all those tweets, by the way…but I also loved the fact that people could Tweet to me while I ran.  It’s so helpful...
55 0 /
Paul Turley
Follow /28 Jan 2015 at 4:26am / SQL Server

New Power BI Preview and Pricing

Some exciting announcements were made today about the new Power BI cloud-based business analytics service.  Today Power BI is an add-on service for Office 365 that requires an enterprise-level license – about $50 per user per month.  Data transformation...
61 0 /
Follow /27 Jan 2015 at 1:00pm / SQL Server

What is a Database Trigger?

All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.  You can get started using these free tools using my Guide  Getting Started Using SQL Server . What is a Database Trigger? A...
122 0 /
Dinesh Asanka
Follow /27 Jan 2015 at 12:19pm / SQL Server

SQL Server 2014 Security Enhancements : User Object Permissions

In many database systems, it is a requirement to grant read permission for all databases. To achieve this, there is no other way but grant read permission to each and every database. Read more http://www.sql-server-performance.com/2015/sql-server-2014...
57 0 /
Chris Shaw
Follow /27 Jan 2015 at 12:00pm / SQL Server

Tip # 3 – Maintain your SQL Server

Top 10 Tips for SQL Server Performance and Resiliency This article is part 3 of 10 in a series on the most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is related to the most common errors I see and is...
54 0 /
Chris Webb
Follow /27 Jan 2015 at 9:30am / SQL Server

Deprecated/Discontinued Functionality In SSAS 2014

Last week while reading Bill Anton’s blog (which is, by the way, highly recommended) I came across a link to a page in Books Online that I hadn’t seen before: a list of deprecated and discontinued functionality in SSAS 2014. Here it is: https://msdn...
49 0 /
Follow /26 Jan 2015 at 8:03pm / SQL Server

T-SQL – Find Number of Rows of Database(s) tables Using Undocumented Procedure – sp_MSforeachdb and sp_MSforeachtable

On Technet forum, Op was looking for a way to get table cardinality for all databases in an instance.  There are many ways to get the result. This post gives you an idea and SQL in which undocumented SP’s being called  “sp_MSforeachdb and...
76 0 /
Basit A. Farooq
Follow /26 Jan 2015 at 5:54pm / SQL Server

An Overview on SQL Server Checkpoints

Commercial database systems like SQL server have many recovery mechanisms to restore data hardware or software failure. Checkpoints are part of such recovery mechanism.SQL Server Database Engine is programmed to perform changes or modifications to databasepages...
73 0 /
Chris Yates
Follow /26 Jan 2015 at 1:52pm / SQL Server

Impact Player Series – Part 1

I wanted to start this series in regards to impact players that go above and beyond in the SQL Community. Coming from a sports background this resonates well with me and by the end of the year will have a 12 person roster. I get asked a lot when I go...
41 0 /