|
|
|
|
Got a SQL Server question that needs answering? SQLblog now has a SQL Server forum that can be found at http://sqlblog.com/forums/57/ShowForum.aspx.
Latest Blog Posts
-
|
I am disappointed in Cisco. I have Vista Ultimate x64 installed on my snappy new Red laptop but I cannot install Cisco VPN Client software on it because Cisco VPN Client does not run on Vista 64-bit platforms. Digging around for a work-around, I came...
|
-
|
Kevin Hazzard did an outstanding job presenting to the Richmond SQL Server Users Group this evening on LINQ To SQL! I really like the ORM / code generation aspects of this new feature of the .Net Framework 3.5. Seeing it in action made me yearn (a little)...
|
-
|
Mladen Prajdić just released SSMS Tools PACK 1.0 . SSMS Tools PACK is an Add-In (Add-On) for Microsoft SQL Server Management Studio and Microsoft SQL Server Management Studio Express. Here are some of the features Uppercase/Lowercase keywords. Run one...
|
-
|
This question came up today and here is one way of doing it. It requires running xp_cmdshell so this is probably not such a good idea. The problem with functions is that you cannot just insert into any table. INSERT, UPDATE, and DELETE statements modifying...
|
-
|
Without running this what do you think will be printed? SET ROWCOUNT 0 DECLARE @ int SET @ = 6 IF @@ROWCOUNT = 1 PRINT 'yes' ELSE PRINT 'no' PRINT @@rowcount Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...
|
-
|
After numerous questions and requests, we decided to create a forum for all SQL Server related questions. You can view the new forum at http://sqlblog.com/forums/57/ShowForum.aspx or use the Forums menu item on the site to browse there. We hope this new...
|
-
|
Introduction I wrote a series of posts recently about the developer community. I started each post with a linked summary of the previous posts, which I will continue here: On Developer Communities... I hold the following hypotheses about successful, growing,...
|
-
|
Introduction A long time ago in a place not so far away from Farmville, I learned Motorola 6800 machine code. It wasn't easy but with patient instruction from my neighbor, I was soon making things happen on the computer screen and in memory. I was hooked!...
|
-
|
I was asked by a developer at work the other day why SQL Server does not have the create or replace syntax. I started thinking and there were some advantages and one big disadvantage First the advantages Advantage When scripting out a database you don’t...
|
-
|
Again, I wanted to blog about something that still does not change between 2005 and 2008. At a recent conference, there were some great questions/ideas that should make it to Connect if they haven't already. When DB Snapshots were first introduced, one...
|
-
|
Adam Machanic has already blogged about Craig's visit to New England coming up on May 8th but I wanted to re-iterate some points for the benefit of the folks planning to attend. Due to the large crowd expected we really need you to RSVP if you...
|
-
|
In the Who do you want to see interviewed next? blog post I asked for some names of people who YOU would like to see interviewed. Erland Sommarskog's name was submitted in comments a couple of times. I contacted Erland and am happy to anounce that he...
|
-
|
In the Who do you want to see interviewed next? blog post I asked for some names of people who YOU would like to see interviewed. Craig Freedman's name was submitted in comments a couple of times. I contacted Craig and am happy to anounce that he has...
|
-
|
I answered this question on the MSDN forums: How can I search all my sprocs to see if any use a function? Several people suggested using sp_depends. You can't really depend on sp_depends because of deferred name resolution. Take a look at this First create...
|
-
|
When SQL Server Agent runs its tasks it normally does so using the context of the service account you assigned to the Agent service. This may or may not be the best context for your application, so you can set up a Proxy. This allows you to run the task...
|
-
|
A frequently asked question that surfaced again today is, "how do I see when my data has been accessed last?" SQL Server does not track this information for you. SELECT triggers still do not exist. Third party tools are expensive and can incur unexpected...
|
-
|
SQL Server 2008 has introduced a long sought after feature -- Data Compression. This is a great feature, and I have no doubt it'll be widely used. The key compression method is called page compression, which uses the following three techniques to reduce...
|
-
|
More Better Last week I read and blogged about Better by Dr. Atul Gawande. In Part III of the book, Dr. Gawande focuses on Ingenuity with three chapters entitled The Score , The Bell Curve , and For Performance . There are lots of good takeaways for software...
|
-
|
Here's the agenda for the May 8th 2008 meeting of the Ohio North SQL Server Users Group. The meetings are held on the 2nd Thursday of every month at 5:15 in the Cleveland Microsoft office. The address of the office is below: Microsoft Corporation 6050...
|
-
|
The New Laptop Is Here! When I returned from Minneapolis, my new Dell XPS 1530 RED laptop was waiting! My lovely bride sent me a text message Thursday to tell me it was in Farmville. I didn't get to play with it until Friday evening, but I've been working...
|
There are
57 guest(s) online.
Currently there are no online users.
|
|
|
|
|