Saving Hard Dollars
Data analysis can save money and resources, but it will certainly transform our world.
SQL Server Reporting Services (SSRS) Log Files for Troubleshooting
Your SQL Server Report Server service will not start or you keep getting an error when you navigate to the SSRS URL? What logging tools are available to assist you with diagnosing SSRS problems, issues, or errors? Check out this tip to learn more.
The Decline of SQL Server
The popularity of SQL Server seems to be high, but there might be reasons to be concerned.
Using the WMI Event Watcher Task in SSIS to Process Data Files
With the WMI Event Watcher Task in SSIS we can import files as soon as they arrive.
You Can Still Vote for PASS
If you couldn't vote last week or didn't get a ballot, you still can. Please go to www.sqlpass.org and learn more.
Ninja Immutable Databases
'Immutable' databases operate under the principle that data or objects should not be modified after they are created. Once again they hold the promise of providing strong consistency combined with horizontal read scalability, and built-in caching. Are Immutable databases a new idea? Are they different in any way from the mainstream RDBMSs?
Data Compression and Snapshot Isolation
Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit
The Final Service Packs
Microsoft has released a final service pack for SQL Server 2008 R2, which many of you might want to install.
Protect Confidential SQL Server Data Q and A
Following on from a webcast, Tim Smith answers some questions on SQL Server security like: Is It Better To Mask At the Application Level Or The SQL Server Database Level? Are there any options to find SSNs in SQL Server besides RegEx? And, why would anyone store sensitive data un-encrypted in SQL Server?
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Cara mengatasi saldo tertahan/pending di KlikBCA
Cara mengatasi saldo tertahan/pending di KlikBCA cukup menghubungi nomor resmi KlikBCA di 08213111109 dan...
BCA KCP Ruko Swadaya TLP/WA 08216977701
Jl. Swadaya Raya No.39 Ruko Swadaya City Square Blok 1.11-23, Kec. Grogol petamburan, Daerah...
Cara cek rekening koran BCA
Cara cek rekening koran BCA silahkan menghubungi saluran resmi BCA di 08213111109 atau whatsapp...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers