Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Your profile
Tag cloud
book business intelligence database dates dmv excel functions gemini gotcha hotfix how to howto indexing interview linq madison performance performance tuning programming sql sql friday sql server sql server 2000 sql server 2005 sql server 2008 sql server 2008 r2 t-sql tip trick xml
Authors
- SQLDenis (164)

- onpnt (82)

- George Mastros (31)

- chrissie1 (8)

- emtucifor (6)

- naomi (6)

- AlexCuse (6)

- thirster42 (4)

- riverguy (1)

- ca8msm (1)

- pmch22 (1)

- ptheriault (1)

- More...
Main Categories
Search
Google Ads
Now that all my server are SQL Server 2008 I use SSMS with SSMS Toolpack and Toad. I don't really use Query Analyzer anymore. The other day I found out that you can hide objects you don't want to see in SSMS by using filters.
Let's first look at some code. Create a new database named test, create a new schema named Denis and then add 3 tables to the dbo schema and 3 tables to the Denis schema. Just run the code below
Here is something interesting to think about
Create this table and insert these 2 rows
Read from your mirror in SQL Server
This will primarily be an extension into the Wiki section on SQL Server Admin Hacks.
OLTP and Reporting
Reporting from OLTP (Online Transactional Processing) databases can be nothing short of difficult at times. The process of reporting of these types on databases can cause blocking, long wait times and in some severe cases, complete failure on the part of the high level operational requirements of the database. In the stage in which we consider how reporting will affect our databases and how to r...
Running static code analysis on SQL Server database with Visual Studio Team System for database architects
To me it seems that Visual Studio Team System 2008 Database Edition is the stepchild of the Visual Studio family. Even in shops that have MSDN Universal/Ultimate subscriptions this version is just not used that much. Maybe it is that long name of this product, I still prefer DataDude. I would like to show you that if you do have licenses for this tool then you should use it because it has some great features. Today we will focus on static code analysis.
Before we start, make sure to grab Microsoft Visual Studio Team System 2008 Database Edition GDR R2
and install that on top o...
Backup and copy warm-standby (log shipped) databases in SQL Server
Most DR solutions include log shipping strategies. Log shipping (LS) is an extremely inexpensive solution for DR and also one I recommend. There is little learning curve to individuals just coming into the administration career for setting LS up and maintaining the flow.
One thing that will undoubtedly be asked of you at some point in time will be to make a backup of the warm-standby database for other purposes. Reasoning for this is commonly due to the geographical location of the standby database verses the online production environment. Often in order to move a backup that ...
:: Next >>


LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.