DBAs have always been warned against using system tables in their code, but often there has been no other way to get information about the server. In SQL Server 2004, Dynamic Management Views have been provided that give you insight into almost every aspect of SQL Server. S. Srivathsani brings us a look at some of the DMVs and functions you can use.
An idea that could save time and resources for backup and recovery in SQL Server.
That’s correct. SQL Server 2005 SP2 supports data compression using Vardecimal data type.
How often do you have those fire drills, testing what you would do in the event of an emergency. Would you be satisfied with a 30% success rate?
How often do you have those fire drills, testing what you would do in the event of an emergency. Would you be satisfied with a 30% success rate?
Learn how to use SQL Server PerfMon counters to track Windows memory. SQL Server MVP Kevin Kline explains the maximum numbers to watch for when using PerfMon memory counters.
How you use dynamic SQL, when you should - and when you should not.
SQL Server isn’t used much for web-based applications, simply because the cheapest ISPs use Linux and Apache for their platform. There are ISPs that provide a .NET platform and SQL Server but it is at a cost. SSDS seems to be Microsoft’s latest attempt to break into the market for database-driven websites.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
aktivasi qlola IB Token BRI (Soft Token) dilakukan melalui whatsapp (O819-6OOO-6O8, Atau 0821_7555_677). unduh...
aktivasi qlola IB Token BRI (Soft Token) dilakukan melalui whatsapp (O819>6OOO>6O8, Atau +62 821>7555>677)....
Comments posted to this topic are about the item The New Wave of Security...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers