Log Shipping Lite with PowerShell
A PowerShell driver that performs incremental restores on a standby server, a lite weight log shipping solution.
2013-07-01
4,646 reads
Articles
SQL Server CREATE TABLE syntax diagrams
Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough to put off the most resolute of code-cutters. However, there is a goldmine of information there, and Phil had an ambition to get at it, and share the gold. The result is this article, full of railroad diagrams.
2013-07-01
4,367 reads
xp_cmdshell for Non-System Admin Individuals
There may be times when you want to allow non-System Admin logins to be able to execute the xp_cmdshell extended stored procedure. In this articleGreg Larson will show you how to setup xp_cmdshell so non-System Admins can use this extended stored procedure.
2013-07-01
3,252 reads
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.
2013-06-28
4,648 reads
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.
2013-06-27
4,668 reads
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.
2013-06-27
3,831 reads
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.
2013-06-27
5,550 reads
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.
2013-06-25
4,095 reads
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.
2013-06-25
5,071 reads
SQL Server Luxembourg User Group
Come join the SQL Server Luxembourg UG for free training and networking on June 27th at 5:30pm. Soren Nielsen will take a Deep Dive into SQL Server 2012’s “Always On” High Availability technology. This will be followed by Vern Rabe of the SQL User Group in Portland, Oregon, presenting “Data Types - Think You Know It All? Think Again”.
2013-06-25
2,225 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Kantor BCA KCP Hasanudin Telp/wa 085169998803
Telp/wa 085169998803 Jl. Sultan Hasanuddin Dalam No.43/48, Melawai, Kec. Kby. Baru, Kota Jakarta Selatan,...
BCA KCP Taman Tekno Telp/wa 085169998765
Telp/wa 085169998765 Kavling Tofi, Blk. A No.3, RW.Sektor XI, BSD City, Kec. Serpong, Kota...
BCA KCP Intercon Megah. Tlp/wa:08218168235
Komp.Intercom Megah, Jl. Joglo Raya Blok W-IV No.27, Srengseng, Kec. Kembangan, Kota Jakarta Barat,...
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