sql server
Tag details
Welcome to the 'sql server' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'sql server'.
Latest blogosphere posts tagged “sql server”
-
The most-watched IT questions this week: Nov. 24, 2009
IT answers —
Authority: 458
New Question Created by Michael Morisy7 hours ago -
You don’t think of them as human… You don’t think of them at all
SQLServerPedia —
Authority: 147
OK maybe I’m feeling really good today… maybe it’s because it’s @Peschkaj ’s birthday… maybe it’s because I needed to find a way to work some Tina Turner into my next blog post…or maybe it’s because I successfully took care of both kids last night for the first time while wifey started some ...8 hours ago -
Taking advantage of Table Variables NOT being transactional - application logging files within a transaction and keeping whats happened
Tony Rogerson's ramblings on SQL Server —
Authority: 400
Table Variables are not Transactional, that is to say BEGIN TRAN....ROLLBACK has no effect on them; we can use that to our advantage. Have you ever been in the situation where you use a log file within your application to log progress, unfortunetly because...( read more )9 hours ago -
Dew Drop – November 24, 2009
Alvin Ashcraft's Morning Dew —
Authority: 127
Jump to: .NET / Visual Studio | Web Development | Design / Methodology / Testing | Silverlight / WPF | Podcasts / Screencasts / Videos | Community / Events | Database | SharePoint | Miscellaneous | More Link Collections | Book of the Day .NET / Visual Studio Source Code for ...11 hours ago -
hardware requirement for sql 2005.
IT answers —
Authority: 458
New Question Created by Infrastucture11 hours ago -
eReleases Press Release Headlines —
Authority: 538
14 hours ago -
SQL Server Schema Automatic Revision History using DDL Triggers and SVN
SQLServerPedia —
Authority: 147
SQL 2005 introduced DDL Triggers, where you could catch events on your DDL statements in SQL, and hopefully most DBA’s are catching them, at least to a table and have some kind of report on who is adding, changing and deleting what objects. What I wanted to do was capture that, but also keep and automatic running ...19 hours ago -
SQL Server Schema Automatic Revision History using DDL Triggers and SVN
stevienova.com —
Authority: 100
SQL 2005 introduced DDL Triggers, where you could catch events on your DDL statements in SQL, and hopefully most DBA’s are catching them, at least to a table and have some kind of report on who is adding, changing and deleting what objects. What I wanted to do was capture that, but also keep and automatic running ...19 hours ago -
SQL Server Schema Automatic Revision History using DDL Triggers and SVN
SQLServerPedia —
Authority: 147
SQL 2005 introduced DDL Triggers, where you could catch events on your DDL statements in SQL, and hopefully most DBA’s are catching them, at least to a table and have some kind of report on who is adding, changing and deleting what objects. What I wanted to do was capture that, but also keep and automatic running ...19 hours ago -
Tired of hearing “M” is to “T-SQL” what X is to Y…
.Net Braindrops —
Authority: 107
I have heard a couple of variations of these analogies. I do not like them. I think they are simply absurd. At last PDC, “M” was to “SQL” what C is to Assembler. This year it was, what VB is to C. And now I even read this: The code name “M” language is like a more manageable (though more limited) form ...22 hours ago -
SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY
Journey to SQL Authority with Pinal Dave —
Authority: 529
Today we will go over a very simple, but interesting subject. The following error is quite common if you use ORDER BY while creating any view: Msg 1033, Level 15, State 1, Procedure something, Line 5 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, ...22 hours ago -
Microsoft Data Development Technologies: Past, Present, and Future
Douglas Purdy —
Authority: 559
http://msdn.microsoft.com/en-us/library/ee730343.aspx This is one of the best articles that I have read about the Microsoft data and modeling history and strategy. Kraig wrote this piece and I love it. Below is at the end of the doc that talks about modeling… Data Development Futures: Modeling If we ...23 hours ago -
What Version of SQL Is That?
MPECS Inc. Blog —
Authority: 130
We have a client that needs to update a Line of Business application that is using a SQL 2005 Express instance. The LoB has a major update coming down the pipe and the product developer has stated that we need to have SQL 2005 SP2 at the minimum to support the newest features in the update. The following SQL ...1 day ago -
Episode 40: Silverlight 4 and Behind the Scenes at PDC 2009 with Scott Guthrie
Deep Fried Bytes —
Authority: 100
What better way to find out what is going on in .Net development than to get it straight from The Gu himself? Keith and Woody were invited back to PDC 2009 to cover all of the announcements and get the scoop on what the future is for Microsoft developers. The guys sit down with Scott Guthrie, Corporate Vice ...1 day ago -
Replication Scripts: Show All Transactional Publications & Subscribers At Distributor
SQLServerPedia —
Authority: 147
Anybody who has talked with me about replication or heard me present about it knows that I recommend using a dedicated remote distributor for anything beyond light replication workloads. Unfortunately neither SSMS nor Replication Monitor provide an easy "one view to rule them all" way at the distributor (or anywhere ...1 day ago -
Replication Scripts: Show All Transactional Publications & Subscribers At Distributor
SQLServerPedia —
Authority: 147
Anybody who has talked with me about replication or heard me present about it knows that I recommend using a dedicated remote distributor for anything beyond light replication workloads. Unfortunately neither SSMS nor Replication Monitor provide an easy "one view to rule them all" way at the distributor (or anywhere ...1 day ago -
How do -you- install SQL Server? (Part 2)
SQLServerPedia —
Authority: 147
Welcome to this series on a thought process around SQL Server Installation. In Part 1 , we started talking about some basic steps and a thought process for a repeatable success story with your SQL Server installations. Today lets continue that story and talk some more about installation planning and success. Well ...1 day ago -
Replication Bug with Partitioned Tables
SQLServerPedia —
Authority: 147
Recently, we came across a bug in SQL Server 2005 on one of our production servers. Apparently, if you execute an ALTER TABLE statement on a replicated table with more than 128 partitions, the log reader will fail. A relatively obscure bug, I know. Microsoft has recognized this as a confirmed bug, but I couldn’t ...1 day ago -
DBA Thanksgiving
SQLServerPedia —
Authority: 147
Last month I went to visit some friends in Montreal. It just so happened to be the weekend right before the Thanksgiving holiday in Canada. While there we happened to meet some new people, which is always nice while traveling. During the discussions with our new friends we came about the topic of Thanksgiving, how it ...1 day ago -
Consolidating SQL Server Environments
Systems Engineering and RDBMS —
Authority: 104
Consolidation is one of the most important topics nowadays in IT/Dev/Production environments. There are a lot of options available to sysadmins, DBAs and Developers to consolidate their environments with the key one being virtualization. For SQL Server consolidation also, there are several different options – ...1 day ago

