Liberty Beta 2 will incorporate all the updates of SQL Server’s Service Pack 3. Furthermore, Liberty Beta 2 will be optimized for the newest addition to Intel’s Itanium® Processor Family, the Itanium® 2 processor. This beta is scheduled to start in late September.
Note: Liberty requires 64-bit hardware with an Intel’s Itanium® or Itanium® 2 processor and will not run on standard 32-bit machines.
A list of tips that should make your code more secure. Note that SQL Server is mentioned in a few places, especially # 4
In this article, we will leverage Extended Stored Procedures to extend the functionality of SQL Server and give a starting point to experiment with Extended Stored Procedures.
Andy takes a look at another entry level book, this one on ADO.Net.
Incepto Ltd. announced the availability of SQL-UP! version 1.3, distributed SQL Server Cluster. SQL-UP! clusters SQL Server databases over LAN or WAN, with no shared storage device.
The software provides business continuity and complete disaster protection for business-critical databases. The new version adds support for online database schema changes, inter-domain clusters and high transaction load.
A VBscript class is created that can be used to query the maintenance plans on an SQL server to determine when a backup has occurred. This class can be used with others to create a scripted method for monitoring backups.
Proc-Blaster 2.32 has been released with much faster loading time, improved help file, new templates and more. Proc-Blaster is a RAD Code Generator for SQL Server.
What's VB.NET? Microsoft has launched a new learning platform called VBTV. Check it out if you are interested in VB at all.
A new SQL Authentication password cracker you should be aware of. It can crack your SQL passwords and give you an idea of how secure you are.
In this follow up to one of our most popular articles, Andy responds to comments posted by readers and discusses how to manage SQL logins effectively in your applications.
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers