Database administrator with 14+ years of hands-on experience in database management and database design. I still remember the morning our CTO walked into our weekly team meeting and dropped the bomb: ...

Autumn is an associate editorial director and a contributor to BizTech Magazine. She covers trends and tech in retail, energy & utilities, financial services and nonprofit sectors. But what are SQL ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

Security researchers have found a new piece of malware targeting Microsoft SQL servers. Named Maggie, the backdoor has already infected hundreds of machines all over the world. Maggie is controlled ...

The SQL Repay tool was created since SQL Server's Replay feature is based on SQL Server Profiler traces rather than SQL Server Extended Events. Other key features of the SQL Replay tool: We don't want ...

The CLR assembly in this project can only be deployed to a SQL Server with CLR enabled, and support for UNSAFE permission set. If you have SSDT, you can open the SQL server project and publish it to ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...