SQL Server

In this article, I will share a nice handy script I found while trying to find a solution to the problem of working on different machines accross the day. Most…

Applies to: SQL Server 2012 SQL Server 2012 Books Online Applies to: SQL Server 2012 SQL Server 2012 Books Online Applies to: SQL Server 2012 SQL Server 2012 Books Online…

Again, if you want to delete all user databases with a single TSQL script, you can achieve this easily by using this script DECLARE @command nvarchar(max) SET @command = ''…

One way to greatly improve your SQL Server's performance is to properly optimize the tempdb database With the tempdb database, you should have one physical file per CPU core in the…

Hi guys, today, I had really enough of backing up my databases due to lots of VM snapshots and restore. I did create in the past an SSIS package, but…

Happy Learning SSIS. SSIS 2008 Series:Introduction to SSIS 2008 SSIS 2008 Series: Transferring data from File to Database SSIS 2008 Series: The For-Each Enumerator SSIS 2008 series:Introduction to variables SSIS…

Studying for the Microsoft Certified Solutions Associate MCSA) certification for SQL Server 70-461 exam - http://spr.ly/6187j1sc 70-462 exam - http://spr.ly/6188j1sY 70-463 exam - http://spr.ly/6189j1sl

To help supplement your MCSA: SQL Server 2012 training, Microsoft Learning presents this series of video reviews of exam objectives and tips, led by Microsoft Certified Trainers -More database certification…

To help supplement your MCSA: SQL Server 2012 training, Microsoft Learning presents this series of video reviews of exam objectives and tips, led by Microsoft Certified Trainers -More database certification…

To help supplement your MCSA: SQL Server 2012 training, Microsoft Learning presents this series of video reviews of exam objectives and tips, led by Microsoft Certified Trainers -More database certification…

This series is the result of effort from a lot of different people. Here is a list of those responsible for getting this series produced and online. by Microsoft Learning…

Kits for you, including: SharePoint 2013, Office 2013, Office 365, Duet 2.0, Azure, Cloud, Windows Phone, Lync, Dynamics CRM, and more. Microsoft Dynamics GP 2010 Guides: Financials Microsoft Dynamics CRM…

R is a programming language and an open-source statistical computing environment used for statistical computing. Derived from the language S (for statistics), R is a GNU project and as such…

[vc_row][vc_column][vc_empty_space][vc_column_text]Learn about the available table storage options for Azure SQL Data Warehouse. One month free trial for SQLDW, simply use referral code "MSConnect": https://azure.com/sqldwfreetrial[/vc_column_text][vc_empty_space][vc_column_text][/vc_column_text][vc_empty_space][/vc_column][/vc_row]

[vc_row][vc_column][vc_empty_space][vc_column_text]Learn how application developers can use Power BI Embedded, an Azure service, to quickly embed stunning, fully interactive reports and visualizations in customer-facing apps.  [/vc_column_text][vc_empty_space][vc_column_text][/vc_column_text][vc_empty_space][/vc_column][/vc_row]

[vc_row][vc_column][vc_empty_space][vc_column_text]Learn about the available table storage options for Azure SQL Data Warehouse. One month free trial for SQLDW, simply use referral code "MSConnect": https://azure.com/sqldwfreetrial[/vc_column_text][vc_empty_space][vc_column_text][/vc_column_text][vc_empty_space][/vc_column][/vc_row]

See how you can add contextual analytics to your application by using the new Power BI client JavaScript API. With the JavaScript API, you can easily make application analytics responsive…

Ross Mistry and Stacia Misner In this book, the authors explain how SQL Server 2014 incorporates in-memory technology to boost performance in online transactional processing (OLTP) and data-warehouse solutions. They…

Stacia Varga, Denny Cherry, and Joseph D’Antoni With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform deliver breakthrough performance, advanced security, and richer,…