microsoft sql
SQL 101 – What is a Database
The term database is used for many different meanings. But if you compared them all, I think you would find that databases are all collections of data that
microsoft sql
t-sql
Quickly Disconnect Users From a Database
Disconnect All Users of a Database There comes a time in every DBA's life when he or she has many users connected to a database that needs to be detached, placed in single user mode, or simply refreshed. The problem is they keep reconnecting more quickly than you can KILL them off. This is especiall
microsoft sql
An Upcoming Series…
I'm currently putting together some notes on a series I'd like to share with all of you. This series will cover the fundamentals of Transactional SQL (T-SQL).
microsoft sql
String Manipulation — CAST and CONVERT
So far I’ve shown you just a few of the many string manipulation functions available in Microsoft SQL. Today we’re adding two more of these tools to
t-sql
String Manipulation — REPLACE, PATINDEX and Regular Expressions
Finding the exact patter can be like trying to a certain snowflake. In the previous SQL posts, I showed you SUBSTRING, then I showed you REPLACE. Now, with
t-sql
String Manipulation — REPLACE
In the last SQL post, I showed you SUBSTRING, and how you could use it to locate the area code in an un-formatted phone number. The problem was the field we
microsoft sql
Work, work, then some more work.
After the last post, I worked on getting a heating system put into the addition. As of last night, that's done. It only cost 3 grand. (that's more than i used
microsoft sql
String Manipulation — SUBSTRING
Sooner or later in SQL, you're going to be asked to change how some text is formatted. Making changes to text is pretty straightforward. First you need