SQL Server

SQL Server Community

SQL Server Blogs

akreul
Follow /28 Jul 2015 at 12:00pm / SQL Server

SQL Server Audit: Getting Started

SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature.  Audited events can be written to the server application or security logs, or to a file where you specify the location (the most secure route...
191 0 /
Denny Cherry
Follow /22 Jul 2015 at 7:00pm / SQL Server

Updating All Jobs To Check For AG Primary Replica

One of the really annoying things about moving existing SQL Server databases into an Availability Group is setting up the jobs to work within the confines of the AlwaysOn Availability Group. This is because you have to manually create the jobs on each...
585 0 /
VSRaavi
Follow /21 Jul 2015 at 7:49pm / SQL Server

SQL Server – New Database Backup Encryption with SQL Server 2014

With the release of Microsoft SQL Server 2014, we have the first version of SQL Server that supports encrypting database backups directly from the database engine without any third party software being installed on the SQL Server. Preparing the Instance...
693 0 /
Ed Elliott
Follow /21 Jul 2015 at 7:38am / SQL Server

Keep your environments in-sync and your upgrade scripts fresh

Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are a few things that we should bear in mind to ensure we do not break existing databases. Why is it important? When you upgrade an application...
410 0 /
Denny Cherry
Follow /20 Jul 2015 at 7:00pm / SQL Server

If You Thought Database Restores Were Slow, Try Restoring From an EMC Data Domain

Recently I did something which I haven’t had to do for a VERY long time, restore a database off of an EMC Data Domain. Thankfully I wasn’t restoring a failed production system, I was restoring to a replacement production system, so I was getting...
500 0 /
derekewilson
Follow /20 Jul 2015 at 8:38am / SQL Server

SQL Server Polybase (2016)

What is SQL Server Polybase? Coming in SQL Server 2016 is the ability to query relational tables as well as data stored in Hadoop or Azure Blob storage.  This technology will allow you to continue to leverage SQL Server for your data warehousing and...
515 0 /
derekewilson
Follow /19 Jul 2015 at 5:40pm / SQL Server

HASSUG BI Developer Presentation on 7/14/2015

I presented on how to become a BI developer at the Houston Area SQL Server User Group (HASSUG).  This session resulted from feedback we received in the user group on differences between database developers and BI developers.  If you are interested in...
678 0 /
Thomas LaRock
Follow /16 Jul 2015 at 8:35pm / SQL Server

HOW TO: Recreate SQL Server Statistics In a Different Environment

Did you know table and index statistics are the most important piece of metadata for your database? The reason for this has to do with how SQL Server (and other database engines) build query execution plans. The query optimizer builds an execution plan...
611 0 /
datachick
Follow /15 Jul 2015 at 3:00pm / SQL Server

What Your Database Security Design….

…looks like to me. Sure, you’ve got your own home-grown database security system all designed and working in development.  And then you ask me to confirm that it’s “safe”. I’ll tell ya “it’s safe as long as you don’t actually put any data in it...
655 0 /
Paul Turley
Follow /12 Jul 2015 at 7:33pm / SQL Server

Power BI General Availability Announced: July 24, 2015

On Friday, James Phillips, Microsoft VP of Business Intelligence, announced that the general availability of the new Power BI Business Analytics Service will be on July 24th.  Also referred to as “Power BI 2.0”, the new service will eventually replace...
380 0 /
Dinesh Asanka
Follow /12 Jul 2015 at 4:54am / SQL Server

Microsoft's Power BI visualization service arrives July 24

Microsoft's Power BI data visualization and business intelligence service will be generally available in two weeks, marking a major milestone for the new product. The launch will bring a smorgasbord of new features, including new chart types, a refreshed...
337 0 /
Paul Turley
Follow /12 Jul 2015 at 12:13am / SQL Server

Online Training event: Designing a Mobile Dashboard Solution with Microsoft DataZen

I’d like to make you aware of a three-hour training event that I will be presenting, hosted by SQL Server Pro Magazine on Thursday, July 30th beginning at 11 AM Eastern Time.  Each one-hour session has a one hour break between and registered attendees...
832 0 /
WaterOx
Follow /3 Jul 2015 at 2:30pm / SQL Server

010 – Ayman El-Ghazali - WaterOx Consulting

Reading Time: 2 minutes The community makes it all happen! In WOxPod!, episode # 009 –... The post 010 – Ayman El-Ghazali appeared first on WaterOx Consulting .
319 0 /
Chris Webb
Follow /3 Jul 2015 at 11:23am / SQL Server

Ensuring Columns Are Always Present In A Table Returned By Power Query

Disappearing or renamed columns in your data source can cause all kinds of problems when you’re importing data using Power Query: errors when you try to refresh the query, broken calculations in Power Pivot, PivotTables that reformat themselves and then...
346 0 /
regbac
Follow /2 Jul 2015 at 10:19am / SQL Server

SSMS Tip Of The Day – Show Row Count

Today, when clicking around SSMS, I discovered this little helpful trick, that you probably already knew but here it comes anyway. If you want to see the number of rows in a table you can always use Select count ( * ) from TableName but it...
332 0 /