Can deleting rows make a table…bigger?
Michael J. Swart posted an interesting question: he had a large table with 7.5 billion rows and 5 indexes. When he deleted 10 million rows, he noticed that the indexes were getting larger, not smaller.
SQL Server Reporting Services Lookup, LookupSet and MultiLookup Functions
I noticed the Lookup function in SQL Server Reporting Services. In this tip we look at all three SSRS lookup functions: Lookup, LookupSet and MultiLookup.
Bad Management
Bad managers are everywhere, but we can improve and help them with some ideas from other companies. That's if we, as an organization, value our staff.
Resumable Online Index Create and Rebuild Operations
Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later.
How Virtualized?
This week's poll asks about virtualization in your environment. Let us know if you are moving your SQL Server to virtual machines.
Transfer Data to the Cloud Using Azure Data Factory
In this tip we look at how to configure Azure Data Factory to move data from an on-premises SQL Server database to an Azure SQL Database.
Serious Hacking
The biggest government hack ever occurred recently. At least until the next one happens.
Improve the Performance of Your Azure SQL Database (and Save Money!) with Automatic Tuning
Organizations may have many concerns about performance when migrating databases to Azure. Fortunately, Microsoft provides some great tools to help improve performance and save money. In this article, Monica Rathbun explains how to take advantage of these features.
Shrinking SQL Server Backup Files and Speeding Up Backups
With backup compression you can speed up our backups, while making your backups smaller.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Santa HUB Tlpn.0821•3111•185
BCA KCP Santa HUB Tlpn.0821•3111•185 Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota...
BCA KCP Jalan Panjang TLP/WA 08216977749
Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...
BCA KCP Daan Mogot Dua TLP/WA 08218573837
Jl. Daan Mogot No.48 A, Jelambar, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
Question of the Day
May the Fourth Be With You Fun
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