SQL Saturday #120 - Orange County
Come to a free day of SLQ Server training on Mar 24, 2012 in Huntington Beach, CA.
2012-03-12
1,406 reads
Articles
Implementing Microsoft iSCSI Initiator Policies & Multi Pathing
Impementing iSCSI multi-pathing and redundancy policies
2012-03-09
4,043 reads
Solid State Disks and SQL Server
An interesting result from a recent test of SSDs in SQL Server by Wes Brown. A surprising discovery is important for anyone thinking about using SSDs to know.
2012-03-09 (first published: 2010-04-08)
36,269 reads
Working with Variables in SQL Server Integration Services
There are a number of ways that you can incorporated variables into your SSIS Scripts. Robert Sheldon demonstrates how.
2012-03-09
3,911 reads
SQL Server Integration Services - Delay Validation
Using delay validation the designer can control the response of default behaviour of package validation which happens at design time and also at run time.
2012-03-08
5,313 reads
Come to see the SQL Server 2012 Launch at DevConnections
On Mar 26-29 in Las Vegas, the DevConnections conference is hosting a launch of SQL Server 2012. Come to the conference and learn more at the SQLServerCentral track.
2012-03-08 (first published: 2012-01-18)
4,386 reads
How to use RunAs command for SSMS if option does not exist
In order to use your normal Windows login and your admin login to connect to SQL Server using SSMS you need to use the "Run as" feature. What do you do in the case of Windows 7 or Windows Vista where you can’t find the Run As Different User option?
2012-03-08
2,888 reads
Win an Amazon Kindle! Complete our Data Compression Survey
We'd like to find out what you think about SQL Server data compression. Complete this quick survey and you could win an Amazon Kindle. Complete the survey now.
2012-03-08
2,095 reads
Basics of XML and SQL Server, Part 1: Streaming XML
This article demonstrates how to generate an XML stream from SQL Server using the 'FOR XML PATH' statement, and how to explore that XML stream interactively using an XSL transformation.
2012-03-07
7,981 reads
Three Attack Vectors in SQL Server 2005
This article outlines three different tried and tested methods of obtaining access to databases in SQL Server 2005 where no database-level administrative access exists.
2012-03-07
7,422 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Intercon Megah Telpon/WA:08137887595
BCA KCP Intercon Megah Telpon/WA:08137887595.Komp.Intercom Megah, Jl. Joglo Raya Blok W-IV No.27, Srengseng, Kec....
BCA KCP Kreo Ciledug Telpon/WA:08137887595
BCA KCP Kreo Ciledug Telpon/WA:08137887595.Jl. HOS Cokroaminoto Jl. Ciledug Raya, RT.001/RW.006, Kreo Selatan, Kec....
BCA KCP Penjernihan Telpon/WA:08137887595
BCA KCP Penjernihan Telpon/WA:08137887595.Jl. Penjernihan I No.23, Bend. Hilir, Kecamatan Tanah Abang, Kota 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