Working on a recent SQL Server merge replication project we needed to update some of the servers in a merge replication scenario without upgrading all of them. Consider a merge replication setup with a publisher, a distributor and 2 or more subscribers all on the same version of SQL Server, and you need to upgrade the SQL Server version on …
The Service Pack 2 release of SQL Server 2014 introduces a new DBCC command called DBCC CloneDatabase. Books online states: “DBCC CLONEDATABASE should be used to create a schema and statistics only copy of a production database in order to investigate query performance issues. “ Which sounds really interesting. Get all the schema and statistics but no data. Some immediate …
Welcome to the DataBase Corruption Challenge, this is an about weekly blog challenge where I will post a corrupt SQL Server database with some details on what happened to it. If at this point you are already a bit irked by my use of capitalization in the DataBase Corruption Challenge, and the acronym of DBCC that I have used to …
Introducing the DataBase Corruption Challenge (DBCC) – Week 1 Challenge Read more »
Using the GO commend in TSQL to run a batch of code multiple times is something that I commonly do in demo’s and training’s. What amazes me is how many people after the training will tell me that they didn’t know about using the GO command to run a statement multiple times. Here’s how it works. First lets create a table, …
This weeks training as part of the Free SQL Training for the 70-461 certification course is now available on YouTube. This week we covered Aggregating Data and Aggregation strategies. For more information on sessions, take a look at the Free SQL Training course that we have outlined. TSQL Aggregation video The first half is presented by Aaron Buma and the second …
TSQL Aggregation Strategies and Aggregating Data Read more »
I have been asked to help a development team with training so that they can all take and pass the SQL Queries 70-461 Microsoft certification. After looking it over and understanding all the topics needed for the 70-461 SQL Queries certification, Aaron Buma and I we have worked out a plan to get everyone on the development team through this training. …
With SQL Server 2014, there was a new compatibility level introduced, level 120 the new SQL Server 2014 Compatibility Level. SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL Server …
To start with for Transparent Data Encyrption (TDE) we will need to be using Enterprise (or Developer) edition of SQL Server 2014. I am using SQL Server 2014 Enterprise Edition CTP1, which is the early release of SQL Server 2014. Next we need a database to work with. I will just use the Sample Database for Common Table Expressions, a simple …
Enabling Transparent Data Encryption on SQL Server 2014 Read more »
Hekaton is also known as SQL Server In-Memory database, touted to accelerate transaction throughput up to 30x performance increases on existing hardware. With a new latch-free technology Hekaton is claimed to dramatically increase performance. Are you ready to increase the speed of your OLTP databases by 30x?
When you look at the installed programs with SQL Server 2014 CTP1 you see the following: There is no BIDS or Visual Studio installed with CTP1 of SQL Server 2014. After some additional research, and discovering that I didn’t miss something on the installation. There is no more Business Intelligence Development Studio (BIDS) in SQL Server 2014, instead it can be downloaded …
No more Business Intelligence Development Studio in SQL 2014 Read more »