It’s rare to get a call from a customer telling you that the application is fast today and thanks for taking such good care of the database. Instead, you are more likely to hear complaints when things go wrong like slow running queries and timeouts. There is a lot to consider when trying to figure […]
2019-11-30
593 reads
I like to call tempdb the “workhorse” of SQL Server. I’ve heard some other people call it other terms that were not so flattering, but since I like to keep things positive, I’ll stick with workhorse. SQL Server uses tempdb for many things. The obvious uses are temp tables and table variables, but tempdb is […]
2019-11-02
1,153 reads
I remember when Azure SQL Database was first released in 2010. Microsoft has tweaked the name a couple of times over the years, and back then it was called SQL Azure. The largest database you could create was just 50 GB, and there were quite a few restrictions, such as heaps not being supported. Since […]
2019-10-05
461 reads
When I decided to switch careers about 25 years ago, I had no idea how far I would go in tech. I just wanted to leave the profession for which I had trained and become a developer. My goal was to make the switch by the end of 1998. It actually happened in the summer […]
2019-09-07
138 reads
Microsoft announced CTP 3.2 for SQL Server 2019 just a few days ago, but many people working with SQL Server don’t care about this. I run into people at user group meetings and SQL Saturdays who are stuck supporting versions as old as SQL Server 2000, and SQL Server 2008 R2 is still prevalent. I’m […]
2019-07-27
731 reads
Learn a bit about the different results you get from the PERCENT_RANK and CUME_DIST aggregate functions.
2019-06-27
13,239 reads
2019-06-17
4,918 reads
Many of us checked to make sure it wasn’t April Fools Day a couple of years ago when Microsoft announced that SQL Server 2017 would run on Linux. This means that some shops who want to run SQL Server, but not Windows Server, now can. But it also means that SQL Server professionals need to […]
2019-06-15
213 reads
Kathi Kellenberger discusses the challenge of deciding how to describe the content in the sessions she presents.
2019-06-10
378 reads
Aunt Kathi remembers all the SQL Server versions she has worked with over the years.
2019-04-20
399 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
By CHERRYWIFARM- The Best CBD flowers Europe - Wholesale Hemp Flowers Europe
Whatsapp:083135765355 Jl. Kawi No.36, Gading Kasri, Kec. Klojen, Kota Malang, Jawa Timur 65116
By CHERRYWIFARM- The Best CBD flowers Europe - Wholesale Hemp Flowers Europe
Whatsapp:083135765355 Jl. S. Supriadi No.65, Sukun, Kec. Sukun, Kota Malang, Jawa Timur 65117
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers