VB TV
What's VB.NET? Microsoft has launched a new learning platform called VBTV. Check it out if you are interested in VB at all.
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.
It’s almost time for the newest Service Pack for SQL Server 2000, and you don’t want to be caught unprepared for this one. In addition to the normal QFE fixes, the top service pack requests from our PSS organization and the latest security fixes, this service pack will be shipping with MDAC version 2.7 SP1. You’re going to want to be involved in this service pack beta! This beta is scheduled to start in mid to late September.
New columnist Gregory Larsen used to not care what his objects were called until recently when he began to become concerned with the system generated constraint names. This short article tells you why.
This article briefly discusses SQL Server's data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.
Microsoft is now accepting nominations for beta testers for SQL Server 2000 (64-bit), SQL Server 2000 Windows® CE Edition (SQL Server CE) version 2.0, and SQL Server 2000 Service Pack 3 (SP3). Any SQL Server customer can participate.
Bill Wunder has done it again with his newest release of his DDL Archive Utility, which can pull entire schemas into Source Safe automatically.
Recently Steve Jones noticed that someone wanted to use a UDF to enforce uniqueness. No big deal, right? Well this person wanted to enforce uniqueness based on some other column value. A bit of a challenge, but this article presents a couple ways to handle this.
This article introduces TSQLDoc, a Windows Script Host script that extracts procedure metadata and embedded documentation comments from Transact-SQL stored procedures, generates XML documentation for every stored procedure in a database and optionally transforms the XML document into HTML or other format using XSLT.
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
This is more complicated than using the Azure Migration method, but because it’s maxed...
I’ve covered how to create Elastic Jobs in the portal (this one is important...
Accidental DBA here. After looking at all the work that needs to be done,...
Hello SSC, Hope you are all having a great Monday! I am trying to...
I'm having a bit of an issue with SSRS permissions. Users (Operations Manager Report...
Which of these is not a requirement for a database to be added to an Availability Group (AG)?
See possible answers