2022-07-02
70 reads
Database Weekly
A New SQL Server Vulnerability
A new vulnerability for SQL Server is covered by a number of patches this week.
2022-06-18
619 reads
2022-05-28
200 reads
Moving on but not far
During my technical career, I’ve changed companies several times. I even worked as an independent contractor for three years. One thing I have never done before was switch departments and roles within one company. That’s about to change in a couple of weeks as I move from Simple Talk Editor and DevOps Advocate in Marketing […]
2022-05-21
90 reads
Finding New Employment
You can find new employment with a little work and choose the best job for you.
2022-05-07
121 reads
What will convince you to upgrade?
You’ve probably heard that SQL Server 2022 is on the way, and, assuming the name doesn’t change, it will be later this year. That is great news for folks in the data platform community as features and improvements they’ve been hoping for are added. I’m not currently supporting any production SQL Servers, but I’m still […]
2022-04-30
97 reads
Constant Azure Improvement
This week I noticed a number of changes in the Azure platform from their change feed. Actually, every week has a crazy number of changes across the entire platform, but this week a number of these were related to data and databases. That isn't always the case, but I saw some interesting items. We have […]
2022-04-16
70 reads
Document yourself out of a job
Some organizations have policies in place to make sure that everything in their IT infrastructure is documented. There are runbooks, procedures, wikis, diagrams, charts, code comments, and more to make sure that knowledge is available if an employee leaves or when disaster strikes. Not only does the documentation exist, but it’s also organized and easy […]
2022-04-09
182 reads
2022-03-26
96 reads
SQLBits Report
Last week I attended my first in-person event in over two years. SQLBits, the largest data platform conference in Europe, was a hybrid event and marked the first time many of us met in person in ages. It was a huge success as folks from around the world gathered to learn...and celebrate! I heard several […]
2022-03-19
89 reads
Blogs
Get Configuration Change History From the SQL Server Error Logs
By SQLPals
Get Configuration Change History From the SQL Server Error Logs There...
A NEW’er Solution For An Old Problem: How To Gain Access To SQL Server When No DBA Around
By SQLPals
How To Gain Access To SQL Server When No DBA ...
Forums
CXConsumer wait type issue
hello, my query is select * into #TmpA from tblA (nolock). tblA contains 116000000...
How to speed up this?
Hi everyone One of my SSIS components seem to be very slow. I am...
Managing some particular dimensions in a data warehouse based on medical records
Hi, I need to design a data warehouse solution to manage medical records about...
Ask SSC