Why SQL Server 2012 needs Windows Server 2012
While AlwaysOn and Columnar lookup are good enough reasons to migrate to SQL Server 2012, you need to be aware of the problems associated with certain virtualize environments.
2013-07-04
8,297 reads
SQL Server 2012
A Quick Tour of the Performance Dashboard Reports
SQL Server Performance Dashboard comprises a set of custom reports that give you nitty gritty details about the performance of your SQL Server instance.
2015-07-03 (first published: 2013-06-11)
18,304 reads
The Importance of Reading Comments
Read when you search for help on the internet. You might miss a very important part of what you must do.
2013-06-10
4,868 reads
Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets
There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell. Microsoft have put effort into making it much easier, as Allen White demonstrates.
2013-05-23
3,650 reads
Power View for Cubes
This document evaluates the latest functionality provided by Microsoft SQL Server 2012 With Power View for Multidimensional Models[1], this SQL Server 2012 CTP release allows connections between Power View and Multidimensional Models ( cubes) and not just Tabular Models.
2013-05-21
6,391 reads
How Maintenance Plans are a Big Plus for SQL Server Administration
SQL Server 2012 makes your database maintenance jobs easy by proving an effective Maintenance Plan Wizard. This wizard does a fair job of creating core maintenance plans for your database.
2013-05-20
5,026 reads
SQL Server 2012 Integration Services - Using PowerShell to Configure Package Execution Parameters
Marcin Policht explores some of PowerShell's SSIS-specific automation capabilities by demonstrating the process of configuring an already deployed package in order to carry out a parameterized package execution.
2013-04-29
2,381 reads
Upgrading to 2012
Are many people upgrading to SQL Server 2012? Is it worth the cost for your company for any existing instances? Steve Jones asks the question this week.
2013-04-19
411 reads
Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell
With SQL Server 2012 AlwaysOn Availability Groups, you can configure read-only routing and to automatically redirect the read-only workloads to a secondary replica after a failover. Can this be done using Windows PowerShell?
2013-04-17
2,105 reads
New and Basic Result-set Paging functionality in SQL 2012 Version.
Overview of 2 very important clauses added to SELECT statement in SQL2012 to allow paging on result sets.
2013-04-10
621 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers