In August 2009 I wrote a tip concerning checklists for third-party applications running against Microsoft SQL Server. I thought it was a good time to revisit the topic and provide an added bonus: a requirements document that you can download and customize for your own uses.
2010-02-08
2,823 reads
It is again time to play with some date/time values. This challenge involves reading the audit log entries generated by a monitoring application and create a report that shows the up-time and down-time of a system that the application is monitoring.
2010-02-08
2,225 reads
SQL Server MVP and SSIS guru, Andy Leonard, discusses Integration Services and some of the tasks and containers that he uses quite often.
2010-02-05 (first published: 2008-08-21)
96,170 reads
It came as a surprise to many of us when Microsoft pulled from it's hat a rabbit in the form of an exciting, radical, language that offers an effective alternative to the Object-oriented orthodoxy. The creative force behind this language, F#, turns out to be a brilliant Cambridge-based Australian called Don Syme, already well known for his work on generics in .NET. F# has taken the specialised power of ML and OCaml and developed a versatile general-purpose .NET language. We sent Richard Morris across the road to investigate.
2010-02-05
2,621 reads
It is important to ensure that SQL code is laid out the best way for the team that has to use and maintain it. Before you work out how to enforce a standard, one has to work out what that standard should be for the application. So do you dive into detail or create an overall logic to the way it is done?
2010-02-05
4,843 reads
I’ve been working with SQL Server for 10 years and have worked in production with versions 6.5 – 2005 and used...
2010-02-05
1,755 reads
Diagnostic report pack for SSRS that provides monitoring capabilities for all items on the Report Server.
2010-02-04
16,015 reads
The company I work for has migrated to SQL Server 2008 and we're ready to start planning for the use of geospatial data. One of the applications we want to use geospatial data in will assist order fulfillers in efficiently picking stock for orders. Our warehouse is fairly large, which geospatial data type should we use?
2010-02-04
2,378 reads
One of the most common mistakes made in T-SQL is thinking that these behave identically. I've personally opened up a...
2010-02-04
3,941 reads
Recently Ben Kubicek created a script that would allow him to copy his production db to a test instance and correct the production specific SQL code in stored procedures and views.
2010-02-03
7,464 reads
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Jl. Daan Mogot No.KM. 11, Wisma SSK, Kecamatan Cengkareng, Kota Jakarta Barat, Daerah Khusus...
Jl. Pesanggrahan Jl. Puri Kencana No.28 29, Kembangan Sel., Kec. Kembangan, Kota Jakarta Barat,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers