Data Collector in SQLServer 2014 – What’s New !
Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting...
2014-04-08 (first published: 2014-04-04)
3,779 reads
Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting...
2014-04-08 (first published: 2014-04-04)
3,779 reads
Hot cake for the day is SQLServer 2014 RTM bits. Its generally available starting today, and I downloaded a fresh...
2014-04-01
19,240 reads
The cost associated with Outbound Data Transfer is very important when you consider bridging your On-premise network with Windows Azure.
Yes, when I...
2014-03-25 (first published: 2014-03-19)
2,675 reads
I learned something new today while I was listening to one of the courses on corruption authored by the master,...
2014-02-06
1,556 reads
The cached MSI file ‘C:\Windows\Installer\<name>.msi’ is missing !!! This is one error which you don’t want to see when you are...
2014-01-14
1,200 reads
Apparently,setting up the Min and Max Memory setting for SQLServer should be definitely encouraged and no server should be left...
2014-01-02
817 reads
I got motivated to write this post as there was a question on twitter which was like -
The user was...
2013-11-12
1,249 reads
SQLServer 2014 CTP2 came with an inbuilt tool called Memory Optimization Advisor which will help you in migrating your normal...
2013-10-23
1,199 reads
SQL Server 2014 CTP2(All new,shiny shiny !) availability was announced yesterday at #SQLPASS Summit.
Native backup encryption is one of the key...
2013-10-17
1,761 reads
Couple of months back(To be specific in June) Microsoft and Oracle announced their partnership to help enterprise customers embrace the...
2013-09-24
957 reads
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
By Steve Jones
One of the things I’ve been experimenting with in AI is taking things other...
By Steve Jones
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
We are in the process of upgrading to SQL Server 2022 and would like...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers