Ever have a transaction you need to roll back? Undo a fat finger? There are a number of log reading products available for SQL Server to help with you in this area. Dale Corey takes a look at LOG PI with an extensive review of the product, including a bunch of screenshots..
2004-08-23
8,271 reads
By now everyone should have heard about the PASS 2004 Summit in Orlando this September. Hopefully you are also aware that SQLServerCentral.com is one of the sponsors for this event and to make it a bit special, we're putting on a reception for everyone that registers for PASS with our promotion code. Read on to see what we've got planned!
2004-08-23
4,122 reads
If you're into fantasy football, come waste some time with us and join our free league at Yahoo. Read the below instructions on how to join. Space is limitted in the first league to 12 teams so join quickly and the draft starts Tuesday! If it's popular, we'll create other leagues.
In order to join the league, just go to http://football.fantasysports.yahoo.com/f1,
click the "Sign Up Now" or "Get Another Team" button and
follow the links to "Join a Custom League". When prompted,
enter the League ID# and password below.
League ID#: 525071
Password: ssc
2004-08-20
204 reads
Notification Services is one of the features included in SQL Server 2005. As the name implies, Notification Services are services which send notifications to the interested entities based on what they would like be notified on. In this article you will see how to implement Notification Services in SQL Server 2005
2004-08-20
2,803 reads
A new article from MSDN magazine on stopping SQL Injection attacks by examining how the SQL can be exploited. It's a good basic article for developers as well as DBAs who might have to review code.
2004-08-20
2,865 reads
An article from Microsoft Journal looking at the new Mining features of SQL Server 2005. If you're interested in Analysis Services, this ias a good look (from a high level) at the next version.
2004-08-19
1,617 reads
The final installment in Darren Fuller's series on change management in SQL Server. If you haven't read the others, be sure to go through them before reading this one to learn how automating your version control in SQL Server is needed for any development shop.
2004-08-18
7,340 reads
SQL Server can grow to encompass hundreds of databases on a single server, each having hundreds or thousands of objects within it. A truly scalable RDBMS. However, how many times have you been searching through the Object Browser in QA or the left pane in Enterprise Manager searching for an object? New Author Ashish Kaushal gives us a method to easily search your server for that long lost object.
2004-08-17
19,385 reads
Analyzing the data storage in SQL Server databases is a bit of an art. It's a skill that takes some time to develop given that the tools are rather limited. DBCC SHOWCONTIG is one of the few ways in which you can get some insight into how SQL Server has structured your table on the disk. Joe Sack brings us another of his top xxx techniques with his ten queries that you can use to analyze the results of this command.
2004-08-16
23,097 reads
SQL Server has great client side tools, Query Analyzer, Enterprise Manager, for working with your server and managing it. But how many times have you wished for a web interface because you didn't have VPN or didn't want to give rights to a developer. Or maybe you host clients' databases on your server and don't want one person to see another's databases. Read this review by someone who actually uses this product.
2004-08-13
9,007 reads
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers