Let’s step back in time and discuss the history of Structured Query Language, or what most SQL Server professionals just shorten to SQL. Fasten your seatbelts, crank up the time machine and travel back in time to follow the history of SQL and Microsoft SQL Server from its early years to where they are today.
This week Steve Jones asks about the versions of SQL Server that you have to support in your daily job. Answer this week's poll and let us know the width and breadth of support that you are responsible for maintaining.
This paper describes how to identify and resolve spinlock contention issues observed when running SQL Server 2008 applications on high concurrency systems with certain workloads.
A data flow task generated by the SSIS Import and Export Wizard can be configured to extract data from multiple files by changing the default connection manager to a MultiFlatFileConnection.
Steve Jones talks NoSQL today, which should stand for Not Only SQL, according to Dr David DeWitt. The final keynote last week discussed SQL alternatives and their impact on our data world.
A tale from the days when civilization was young and everything was harder than it is now.
Even where Source Control isn't being used by developers, it is still possible to automate the process of tracking the changes being made to a database and put those into Source Control, in order to track what changed and when. You can even get an email alert when it happens. With suitable scripting, you can even do it if you don't have direct access to the live database. Grant shows how easy this is with SQL Compare.
On Thursday October 20th ,MVP Louis Davidson will discuss the why normalized databases are the most important part of query tuning
A lively comparison of Pascal's triangle to root cause analysis from David Poole.
How hard is it to anonymize data? According to some research, it might be close to impossible. The problem is that we are gathering so much data that cross referencing data sets becomes a problem. Steve Jones talks today about the implications of this for security.
By Vinay Thakur
it has been a year since i have not written much on the blog...
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers