Tampa Code Camp Revivial
If you were to look around Florida at the various cities technology based User Groups, and their accompanying local conferences you...
2014-07-21
763 reads
Rename SharePoint Central Administration Database
SharePoint uses a series of SQL Server databases to save configuration information, security setups and all the user data that...
2014-07-21
1,456 reads
Steps to install Service Pack for SQL Server 2005 – Multiple Instances
Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :- Step 1 : First page of Service pack setup. Informatory details only. Step...
2014-07-21
23 reads
Powershell Tips–Showwindow
Looking for help is a pain in Powershell. I type something like
help get-process
execute this and I’m scrolling up and down....
2014-07-21
1,166 reads
July 2014 – SQL Server Monthly Maintenance Checklist
image source
It’s been a few months since I’ve updated my SQL Server monthly maintenance checklist. Even though it hasn’t been...
2014-07-21
738 reads
Null Values in SQL Server
Walk & Talk #001 – Unknown or Null Values
Ride with us in this video as we head to Richmond, Virginia to present...
2014-07-21
629 reads
Last Weeks Top “Reading” Links #93
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-07-21
994 reads
Victims of Success
I took part in the PASS Summit 2014 selection committee this year because I was really curious about seeing how...
2014-07-21
677 reads
Steps to install Service Pack for SQL Server 2005 – Multiple Instances
Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :-
Step 1 : First page of...
2014-07-28 (first published: 2014-07-21)
8,021 reads
Add them to ALL the roles!
I seem to get a lot of permissions questions these days and one of the more frequent ones goes along...
2014-07-28 (first published: 2014-07-21)
8,682 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers