Download session materials and watch the recordings of my excellent sessions on Transact-SQL and IT careers! I'm looking especially at you, women in technology!
The post Beginning T-SQL and Career...
2019-08-19
27 reads
A misguided attempt to improve security that not only increases the chances of SQL Injection, but also prevented useful changes from being made.… Continue reading Feature Restrictions in...
2019-08-19 (first published: 2019-08-05)
1,279 reads
I have just written the fifth article of the Machine Learning topic. !!! This time it is an example of the process – step by step. Do not miss...
2019-08-17
51 reads
Working on Always On and configuration/setup of AG we have observed many errors. especially when configuration listener with following error 19471 or AG could not configure: Creating availability group...
2019-08-17
46 reads
tl;dr For Windows when you need a different account. I had to work with a new GitHub account recently and needed to add a separate account. I worked through...
2019-08-16
7,136 reads
One of the things that’s handy when working with containers is being able to move files in and out of the container. Certainly you can do this from a...
2019-08-16 (first published: 2019-07-31)
400 reads
Everything else aside two of the most important tasks of a database are to get data in, and get data ... Continue reading
2019-08-16 (first published: 2019-08-05)
322 reads
I have had a few people contact me over the last few weeks asking if David’s ebook “Putting Your Head in the Clouds” is still available. The short answer...
2019-08-15 (first published: 2019-08-05)
279 reads
This is going to be a quick post but this morning I was asked the question, ‘how can I get the name of all the database snapshots on a...
2019-08-15
139 reads
HaHa, tricked you. You can’t install SQL MDS on Standard Edition. You must first upgrade to SQL Enterprise Edition before you can proceed with an MDS installation. Upgrading SQL...
2019-08-15
92 reads
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Hi, we put together an extract that runs every 15 minutes against what i...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Comments posted to this topic are about the item Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers