Automating SQL Server Database Deployments: Scripting Details
To wrap up the series on Database Deployment Challenges, Alexander takes a dive into the details of how he scripted a solution and comes up with several practical tips for getting the most out of any automated database deployment framework.
Better Technical Interviews
Technical interviews don't work great, but are they dead? Is there a better way? Steve Jones comments today.
SQLServerCentral Runs sp_Blitz - Informational Items
The sixth article in our series that looks at the results of the sp_Blitz™ script run against the SQLServerCentral servers.
Export to XML Using SSIS
Exporting data to XML format using SSIS initially seems like it should be straight forward – just dump it in a flat file and give it a name xml type, however SSIS has no XML destination just an XML source. I had no luck dumping the XML in flat file. My solution was to use a script task which worked well.
Free eBook - Control Your Transaction Log so it Doesn't Control You
Download your free copy of SQL Server Transaction Log Management and see why understanding how log files work can make all the difference in a crisis.
Great Engineering Culture
Building great culture in a company is hard, and it takes work. Building great engineering culture can be more challenging, given the strong ideas and opinions people have in technology. Steve Jones has a few thoughts today.
More Data Security Issues
The state of data security is getting better in the US, according to the 2013 survey from Symmatec. However we still have issues.
New SQL Monitor Custom Metric: Database Autogrowth
This metric for Red Gate SQL Monitor measures the number of database autogrowth events (data file or log file) in the last hour. Too many autogrowth events causes disk fragmentation which requires a change in the autogrowth settings of a database.
Painless management of a logging table in SQL Server
Tables that log a record of what happens in an application can get very large, easpecially if they're growing by half a billion rows a day. You'll very soon need to devise a scheduled routine to remove old records, but the DELETE statement just isn't a realistic option with that volume of data. Hugo Kornelis explains a pain-free technique for 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
BCA KCP Muara Karang 2 Telpon/wa.085373737699
BCA KCP Muara Karang 2 Telpon/wa.085373737699.Jl. Pluit Karang Blok D-7-U. 211A Kav.1 & No....
Alamat Kantor BCA KCU PONDOK INDAH Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec....
BCA KCP Cemara Asri CSTelpon : 0853-73737551
Komplek Cemara Asri, Jl. Boulevard Timur No.08B, Medan Estate, Kec. Percut Sei Tuan, Kabupaten...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers