One of the many tasks of the SQL Server Database administrator is to take and maintain backups of SQL Server databases. This includes taking backups of analytical databases as well. Read on to learn how to backup an Analysis service database.
Have you ever needed to figure out which objects in development need to go to production? Ever wondered about how to get your databases back in synch? SQL Server guru David Poole takes a look at SQL Examiner, a product that he feel works well for him and is looking to purchase. Read about David's impressions and see if this is for you.
This article will explore the new Row Versioning feature in SQL 2005, and the two new transaction isolation levels that take advantage of it: Read Committed Snapshot and Snapshot Isolation.
After interviewing a number of database geeks, it struck me that many of them focus on one area of database development. Hilary Cotter specializes in replication, for example, while Itzik Ben-Gan focuses on Transact-SQL (see http://www.simple-talk.com/categories/sql-articles). Scott Forsyth is no different, but his area of expertise is more unusual: web hosting using .NET technology.
The final installment of Steve Jones' series on employee retention. This one examines the employee point of view in looking for and finding the ideal job, which you will then want to look at the other techniques to ensure you are employed for a long time.
I have not been a real big fan of using VPC until recently with the Betas and releases of Visual Studio and SQL 2005. Now I can’t stop creating images with different environments for testing Service Packs, OS, Project Server, VS/SQL2005, etc. I want to share with you and also record the steps I used for making my images run efficiently.
For many SQL Server 2000 DBAs working with text columns in T-SQL is no different than any other datatype. But there are some tricks when you work with very large values that you need to know. Leo Peysakhovich brings us some advanced queries that you might need if you work with large XML documents as he does.
This white paper discusses how to integrate and deploy Microsoft SQL Server Express-based applications by using configuration files and the ClickOnce deployment technology in Microsoft Visual Studio.
It is highly recommended that you not rely on system tables in your application as the values and meanings many change between versions. But for an experienced person that digs into the system often and needs quick answers, these system tables may be a great source of information. Suresh Maganti brings us his recent adventure in finding a reliable way to determine the growth factor of a database.
Determining how you will upgrade your DTS packages to SQL Server Integration Services (SSIS) is the first step in creating a DTS-to-SSIS migration strategy.
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers