(Michael Otey) SQL Server 2014’s new In-Memory OLTP, with its 2x-30x performance improvements, provides a pretty compelling reason to migrate to SQL Server 2014—in spite of the fact that SQL Server 2014 was released just two years after the last SQL Server 2012 release.

(Robert Biddle) You want to reduce the load time of your SSIS packages, but you found that the source of the problem is that you are doing full comparisons between your source system and your destination. Perhaps you’ve come to find that your source system has been difficult for you to detect when d

(Chris Webb) You’re probably aware that, in Power Query, a query can return a function. So for example here’s a very simple query (so simple that no let statement is needed) called MultiplyTwoNumbers with the following definition:

(Melissa Coates) This week our team at BlueGranite decided that the sample relational database called ContosoRetailDW would be best located for our demo & training purposes in Azure as a SQL Database.

(Arshad Ali) Have you ever wondered, especially in the case of a data warehousing scenario, why the transaction log file grows bigger and bigger and sometimes even much bigger than your actual database’s data files? What caused it to happen? How do you control it? How does the recovery model of a da

(Pinal Dave) SQL Server 2014 has new cardinality estimation logic/algorithm. The cardinality estimation logic is responsible for quality of query plans and majorly responsible for improving performance for any query.

(Dinesh Asanka) Backup options are changing with every release of SQL Server. With SQL Server 2014, several important backup features have beenintroduced.

(Chris Yates) Being a DBA and working with various teams, I have become accustomed to deploying SSIS packages. I’ll even go back further and, dare I say, DTS packages (I hope everyone did not just fall on the floor while reading that). Now-a-days this Database Professional does more deploying packag

(Jody Roberts) These days, no one can afford to be without monitoring. SQL Server has some cool tools built in for monitoring, most notably extended events, sp_Serverdiagnostics (SQL 2012 and up) and DMV’s.

(Derik Hammer) The ability to script out the definitions of objects is valuable to any DBA. Most of us are intimately familiar with SQL Server Management Studio’s capabilities in this regard. Simply right-click on your object and navigate to the “Script object as” sub-menu.