(Kenneth Fisher) INSERT INTO SELECT and SELECT INTO may be very similar commands but they have some important differences. Every now and again I see people getting confused by the similarities and missing the differences. So here is a quick check list.

(Pinal Dave) I like challenges and when we are faced with a challenge – I just cannot sleep. I am in constant search for solution. More importantly I look forward for the learning experience these bring to me. Recently a senior developer was talking to me and got me thinking.

(Ben Snaidero) If you read my last tip you can see the performance benefit that can be gained by using the new In-Memory OLTP feature available in SQL Server 2014. This tip will extend that test by using some additional options available with the In-Memory OLTP feature to see if we can realize any f

(Kris Wenzel) All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.

(Chris Webb) In part 1 of this series I showed how you can set properties for Power Query function parameters so that saw a description, an example value and a dropdown list containing allowed values when they invoked the function. In this post I’ll show a slightly more complex use of this functiona

(Don Castelino) Recently I worked on a scenario where the requirement was to host more than 25 SQL server instances on a cluster. SQL supports 50 instances on a failover cluster if SMB file shares are used to host the databases. In this blog, I have shared the steps to implement the SMB file share a

(Prashant Shekhar) There are situations where you might have a large SQL Server database that you need to replicate. Since the database is very large we want to initialize the Subscriber from the SQL Server backup and not use a snapshot. How do we bundle all the steps together to achieve this witho

(Kenneth Fisher) The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on whether a date or int column was better as a clustered index.

(Kevin Kline) Microsoft has been pouring R&D resources into building out its business intelligence (BI) feature set and the upcoming SQL Server 2014 (SQL2014) release will continue that trend.

(Pinal Dave) I am always notified by my blog readers whenever they see something unusual and I try to help them so that I can learn something new. Recently, one of my blog reader told that his drive is getting filled with the regular backups taken via SQL Server Maintenance Plans.