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
2004-08-18 (first published: 2004-04-13)
198 reads
This procedure will execute, taking two parameters, (the 2 db names, and will then list out the major object and schema changes for you. It is pretty sraight forward and suggestions are appreciated. It's a good utility for a DBA to track changes after upgrades, etc.. Each portion is easily convertable to a stand alone […]
2004-08-02 (first published: 2004-07-16)
1,100 reads
I don't remember where I found this little gem, but as a VB Developer it has simplified retrieving dates on many projects. Simply pass the function a datetime value and the format that you want in VB style syntax and the date is properly returned. I have modified it slightly from the original author (who […]
2004-07-23 (first published: 2004-06-24)
298 reads
This procedures grants execute permissions to all the stored procedures in a database to the role/user supplied as the parameter. the default is Execute_StoredProcedure. Execute this procedure local to the database you need to grant permissions.
2004-07-22 (first published: 2004-06-21)
340 reads
How many times do you need to estimate space for a new application? Or estimate growth for an existing one? We've had a new contribution to the freeware section of the site. Tablesizer will allow you to guesstimate how much disk space you'll need. Take a peek if you need it, rate the product and give the author any feedback you have.
2004-07-19
3,779 reads
Books on line has been updated since the release of SQL2000.
If you check the documentation for the sp_addlogin stored procedure and example E says
SELECT CONVERT(VARBINARY(32), password) then you should update your installation.
2004-07-16
193 reads
Dark Horse CRM is an enterprise-class Customer Relationship Management application that allows companies to better develop and maintain customers. Visit www.darkhorsecrm.com for more information and to download the free version of Dark Horse CRM that runs on Java, Apache Tomcat, and MSSQL or PostgreSQL.
2004-07-07
3,877 reads
A key service pack has now been released for Microsoft SQL Server Reporting Services. This one adds key enhancements and fixes many bugs.
2004-06-25
1,937 reads
This is rich. A hotel sets up Internet access using Linux for guests. But they run SQL Server internally. So much for all the FUD coming from MS.
2004-06-14
3,811 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers