Creating Dynamic Outputs in SSIS to an SQL Database
This article shows how you can dynamically split data based on transaction type to its own destination table using Integration Services.
Live Blogging from the PASS Summit
Tim Mitchell is the SQLServerCentral correspondent at the 2010 PASS Summit.
An Overview of Extended Events in SQL Server 2008
In this tip we look at Extended Events for SQL Server 2008 and how they are different from earlier tracing and troubleshooting methods.
MS SQL Server 2011 aka Denali, Next Version of SQL Server - CTP 1 Now available!
Ladies and Gentlemen, SQL Server 2011, aka Denali, CTP 1 is now available as public download :
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9
Although, I'm not attending...
Code of Conduct for Software Maintenance
A number of companies came together to develop a code of conduct recently for software vendors. Steve Jones thinks this is a good idea.
A Brute Force Way to Compress a Database
There are a handful of scripts out there to compress all of of the objects in your SQL 2008 database...
Return to Sender: Identity Values and Triggers
By quickly and easily obtaining the identity value, the OUTPUT clause of an INSERT statement can obtain the auto-generated identity value of a row, and so will allow the application to immediately reference the new row or add rows to another table that use the identity value as a foreign key reference.
No free lunch in the Orchard
Phil Factor finds much to admire in Microsoft's new Orchard application but is frustrated by a design decision that seems to limit its use to low-volume applications, with less stringent security requirements.
Red Gate releases new SQL Monitor 2.0: The future of monitoring is wherever you are
A two-year project involving a team of 15 people, a Future of Monitoring blog, input from thousands of IT professionals, and hundreds of hours brainstorming about how the world is changing has led to Red Gate’s newly released SQL Monitor.
Should You Write Down Your Passwords?
Today we have an older editorial by Steve Jones being republished. This piece talks about security and why it might be a good idea to write down those passwords.
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 Pecenongan Tlpn/wa:085373737551
Jl. Pecenongan No.86, Kb. Klp., Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta...
BCA KCP Raya Serpong,Telp/Wa 0821.3111.159
Jalan Raya Serpong 06, RT 008 RW 02, Pondok Jagung, Serpong Utara, Kota Tangerang...
BCA KCP Senayan City Tlpn/wa:085373737551
Mall Senayan City Unit 6-09A, Jl. Asia Afrika Lot 19, Daerah Khusus Ibukota Jakarta...
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