By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the Auto Update Statistics setting is turned on by default,...
2017-09-06
6 reads
Dear All,
In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be...
2017-09-03
707 reads
Dear All,In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be available for SQL Server 2012 :)For folks who...
2017-09-03
593 reads
Dear All,In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be available for SQL Server 2012 :)For folks who...
2017-09-03
1 reads
Dear All, Very happy to share the 8th interview of #DataChannel. Dr. Leila Etaati MVP, MCT from New Zealand discusses Machine Learning using Microsoft Business Intelligence tools in...
2017-08-28
14 reads
Dear All, Very happy to share the 8th interview of #DataChannel. Dr. Leila Etaati MVP, MCT from New Zealand discusses Machine Learning using Microsoft Business Intelligence tools in...
2017-08-28
Continuing on the series on SQL Azure Databases - Active Secondary, this post will explore the task of failing over to...
2017-06-09
424 reads
Continuing on the series on SQL Azure Databases - Active Secondary, this post will explore the task of failing over to secondary.
Fairly straightforward task, just one needs to take...
2017-06-09
9 reads
Continuing on the series on SQL Azure Databases - Active Secondary, this post will explore the task of failing over to secondary.
Fairly straightforward task, just one needs to take...
2017-06-09
4 reads
As a continuation of "SQL Azure Databases - Active Secondary" series started earlier, this post will cover how to connect to...
2017-05-27
637 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers