Powershell Database Backup Script
Learn how to write a script for regular database backups using Powershell and SMO.
2013-05-17 (first published: 2011-01-05)
22,469 reads
Articles
2013-05-17 (first published: 2010-09-22)
11,246 reads
Getting Started Formatting SSRS Reports
Once you've prepared an SSRS report, it needs formatting to get it ready for the people who need to read it. This tip covers the basics of formatting SSRS Reports.
2013-05-17
4,234 reads
How to Change the SQL Server Name after Renaming the Windows Host
This article shows how to change a SQL Server name after changing the Windows machine name.
2013-05-16
61,127 reads
Getting Started Testing Databases with tSQLt
There are several frameworks for assisting with the testing of SQL Server databases, but tSQLt is popular because it is written in TSQL and is simple for a database developer to set up and use. It doesn't get in the way. Rob Sheldon shows you how to get started.
2013-05-16
5,333 reads
#22: What counts for a DBA
In this session Louis Davidson, Microsoft MVP, discusses how being observant of the environment you work in can help you make sure that you are aware of the health of your database systems, as well as your career. You can watch the complete webinar here. Answers to any questions asked are further down the page, […]
2013-05-15
964 reads
Using XML from data variable option in SSIS
Learn how you can manipulat XML documents solely in memory. No file required.
2013-05-15
13,582 reads
Webinar: Forgotten Rings and Other Monitoring Stories
In this session, Grant Fritchey, Microsoft MVP, drills down into a few of the more obscure monitoring metrics that can give you very precise information about exactly what's happening within your server. He'll also show you how you can use custom metrics to enable these metrics in Red Gate's SQL Monitor.
2013-05-15
186 reads
Webinar: Using SQL Storage Compress by Steve Jones and Brad McGehee
Steve Jones and Brad McGehee lead you through real-world examples of working with SQL Storage Compress
2013-05-15
313 reads
Forwarding Pointers in Heaps
When no clustered index is defined on a table, that table is said to be a Heap. Heaps are not ideal when it comes to performance but there are lots of instances where you have heaps.
2013-05-15
3,128 reads
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 Fatmawati Telpon/CS:.085188120691
BCA KCP Fatmawati Telpon/CS:.085188120691 Jl. Komp. Rs. Fatmawati No.1, Cilandak Bar., Kec. Cilandak, Kota...
BCA KCP Saharjo Hub.0813•7887•595
BCA KCP Saharjo Hub.0813•7887•595.Jl. Dr. Saharjo No.149 G-H, Manggarai Sel., Kec. Tebet, Kota Jakarta...
BCA KCP Otista Tlp (+62 821°3111°179
Jl. Otista Raya No.109, RT.13/RW.8, Bidara Cina, Kecamatan Jatinegara, Kota Jakarta Timur, Daerah Khusus...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers