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,066 reads
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
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
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
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,901 reads
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,162 reads
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
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
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
This article contains a T-SQL script that can show you the dependency of all objects in your SQL Server database.
2012-10-30
4,768 reads
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Following on from my previous post on building The Burrito Bot, I want to...
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Comments posted to this topic are about the item Working Better Under Pressure
Comments posted to this topic are about the item Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers