Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

A Technical Community for IT Professionals

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.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

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

DiscussShareLearn

Top Forum Users

The top ranked users for the past 30 days:

Google Ads

0
comments

Deploying Database Changes with PowerShell

by Eli Weinstock-Herman (tarwn) on May 17, 2013 in category Database Programming. Article views: 2132 views.
Recently, while working on a personal project, I found myself needing a lightweight way to deploy database changes to multiple environments. In the past I have used a wide range of methods, ranging from applying the changes manually to applying changes via a diff tool (SQL Compare), to automatically applying manually created change scripts, to automatically applying diff scripts that were automatically generated, to working directly in production..er, pretend you didn't see that one.
Read More...
2
comments

A big loss to our community

by Ted Krueger (onpnt) on May 15, 2013 in category Other. Article views: 1251 views.
Today was a very sad day for me. I received news that a dear friend, Rose Waters @SQLRose, whom I had the pleasure of working with, passed away yesterday. Rose was an all-around great and very intelligent, hard working person. Her energy in wanting to l…
Read More...
0
comments

SQL Server Database owner ~~UNKNOWN~~

by SQLDenis on May 14, 2013 in category Microsoft SQL Server Admin. Article views: 4552 views.
Today I was checking an older server and decided to run sp_helpdb. On a bunch of databases I noticed that the owner was ~~UNKNOWN~~. The only reason I noticed this was when I tried to look at a specific database which is mirrored. I was greeted with thi…
Read More...
0
comments

T-SQL Tuesday #42: The Long and Winding Road

by Koen Verbeeck on May 14, 2013 in category Business Intelligence. Article views: 4569 views.
It’s the second Tuesday of the month, which means it’s time again for #TSQL2sday! It is the 42nd installment of this blog post series and the subject is not about the Answer to the Ultimate Question of Life, the Universe, and Everything as I hoped it wo…
Read More...
2
comments

Modify a Power View Data Source

by Koen Verbeeck on May 8, 2013 in category Business Intelligence. Article views: 8415 views.
This blog posts explains how you can modify the data source of a Power View report published on SharePoint.
Read More...
2
comments

SQL Server Baseline Collection

by Ted Krueger (onpnt) on May 7, 2013 in category Database Administration. Article views: 9776 views.
SQL Server baseline collection is an important task that is too frequently overlooked.  Collecting information on how SQL Server is both providing data services and reacting to how those data services are being utilized, creates a foundation for efficie…
Read More...
0
comments
This is one of those things that I only need once every several months and always forget how to do. Working with custom XML in Visual Studio is a whole lot easier with intellisense. Schema errors are highlighted, enumerated values are displayed, and the amount of typing goes from full tag names to just a few characters followed by tab to complete.
Read More...
1
comments
There are now Visual studio project templates available for creating Nancy projects.
Read More...
10
comments

Employers, Employees and Loyalty, Oh My!

by chopstik on May 1, 2013 in category Professional Development. Article views: 11076 views.
I recently read an article discussing the idea of loyalty, particularly as it applies to millennials – those of the youngest generation currently working. The article was titled “The Truth About Millennials and Job Loyalty”.  I found the article to be a…
Read More...
0
comments

Fixing a SQL Server could not spawn FRunCM thread error

by SQLDenis on Apr 30, 2013 in category Microsoft SQL Server Admin. Article views: 11067 views.
I had to change the account that some SQL Server boxes were using to run the SQL Server services. After I changed the account on one machine from DomainName\User to DomainName\NewUser SQL Server wouldn't start up In the error log I saw the following…
Read More...

:: Next >>