SQL Server 2012: Installing Data Quality Services
Greg Larsen shows you how to install Data Quality Services and the companion client tool called Data Quality Client for SQL Server 2012.
2012-11-07
2,181 reads
Articles
Tracking Database File AutoGrowth with Event Notifications
As discussed in my previous Getting Started with SQL Server Event Notifications article, SQL Server Event Notifications allow us to capture and handle events that occur inside the SQL Server database engine. Event Notifications execute for DDL Events and Trace Events and we can use to capture information about the event that fired, and automate […]
2012-11-06
9,067 reads
Free eBook: SQL Server Hardware
A free eBook from SQLServerCentral and Red Gate software can help you learn about the best hardware for your SQL Server instances.
2012-11-06
5,763 reads
Using SQL Server Concatenation Efficiently
This article shares some tips on using concatenation efficiently for application development, pointing out some things that we must consider and look at when concatenating values or fields in our queries or stored procedures.
2012-11-06
3,661 reads
SSIS Basics: Using the Execute SQL Task to Generate Result Sets
The Execute SQL Task of SSIS is extraordinarily useful, but it can cause a lot of difficulty for developers learning SSIS, or only using it occasionally. What it needed, we felt, was a clear step-by-step guide that showed the basics of how to use it effectively. Annette Allen has once again cleared the fog of confusion.
2012-11-05
2,246 reads
Last chance for a day of free SQL Server training at SQL in the City 2012
SQL Server developers and database administrators have one last chance for a full day of free training and networking at SQL in the City 2012.
2012-11-02 (first published: 2012-10-25)
3,902 reads
Parsing Parameters in a Stored Procedure
This article shows a clean non-looping method to parse comma separated values from a parameter passed to a stored procedure.
2012-11-02 (first published: 2010-08-10)
31,166 reads
SQL Server Function to return a range of dates
A quick solution is a table function that will create a date range based on the parameters given. Then, you can just join to the results.
2012-11-02
4,979 reads
Manipulating XML Data in SQL Server
When the average database developer is obliged to manipulate XML, either shredding it into relational format, or creating it from SQL, it is often done 'at arms length'. A shame, since effective use of techniques that go beyond the basics can save much code,
2012-11-01
3,886 reads
SQL Server Reporting Services 2012 Permissions
As you begin developing reports for deployment to a Report Server, what security considerations need to be taken into account in order to grant users access to run a report.
2012-10-31
3,976 reads
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 Mal Pondok Indah Telpon. 08388331767
WhatsApp 08388331767 Ground Floor G31 & G32, Jl. Metro Pondok Indah, Daerah Khusus Ibukota...
BCA KCP Teuku Umar Denpasar Tlpn Cs:+628213111185
Jl. Teuku Umar No.91, Dauh Puri Klod, Kec. Denpasar Bar., Kota Denpasar, Bali 80228
BCA KCU BENGKULU TELP/CS:083135765355
Whatsapp:083135765355 Jl. S. Parman No.66, Kebun Kenanga, Kec. Ratu Agung, Kota Bengkulu, Bengkulu 38223
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