Who Has The Monitor?
A Friday distraction from work when you have time. Can you figure out who has the dual 19" LCD monitors?
Review: Red Gate SQL Bundle 5
When architects speak with database administrators, it is important they come forearmed. Tools can help. While Microsoft's own database management tools cover the most common database administration scenarios, they don't do anything about some of the most common pain points faced when you need to maintain and deploy SQL Server databases for projects under active development. That's where Red Gate comes in.
SQL 2000 DBA Toolkit Part 3
Phonetic matching, working on finding terms that are misspelled, is an art and there are a number of ways to handle it. In SQL Server 2000 the tools are limited, but Michael Coles brings us part 3 of his toolkit with some handy functions that can help you with text searching.
The Writing on the Wall
There is a world of difference between the business processes that really take place in a company and the management's understanding of those processes…
Business Continuity for SQL Servers With a Standby Approach
Ensuring the availability of your database servers is becoming more important all the time. Fortunately you have more choices than ever. Bilal Ahmed looks at some of the possible solutions available for SQL Server.
OUTPUT clause in SQL Server 2005
A SQL Server 2005 feature that I appreciate and want to demonstrate is the OUTPUT clause. The OUTPUT clause helps in returning the actual data from a table soon after an insert. Applications require return values such as the new identity value, the computed column value or the default value generated by the default constraint.
Data Extraction Methods Part 1
The third part of a great data warehousing series from Vincent Rainardi looks different methods of extracting data from the source system along with the advantages and disadvantages of each.
Making Complex Data Simple: Transforming Your Data Transformation
This article examines the problem of complex data in integration projects and presents solutions for handling this data to create seamless integration throughout the enterprise.
Spotlight on SQL Server
After a bit of a hiatus, the interviews are back. This time we take a few minutes with Dan Jones of the SQL Server development team.
Testing SQL Server restores
Testing is key to ensuring a process actually works when it comes time to implement, rather than finding out when time may be of the essence. This holds true for testing SQL Server restores as well.
Blogs
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
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