Here's a little replacement for Query Analyzer that appears to provide most of the functions, plus a few more. While we haven't given it a full review, at first glance it appears to do the job. Plus there's NO INSTALL!!!! Always a plus for me.
How many of you register a server in Enterprise Manager? Now how many of you click the "save password" box? Probably most of you. Are you aware of the security risks associated with this? James Travis looks at one of potential problems here and other security issues relating to SQL-DMO.
Another look at how the next version of SQL Server will integrate and work with .NET technologies.
Although Brian likes that Microsoft delayed the next release of SQL Server for quality, he disagrees with the release strategy. See his opinion and argue your own!
It's been some time and he apologizes. This next part of this series from Steve Jones looks at selective auditing changes to data on the server using a combination of methods presented in previous articles in the series. Read on if you have problems tracking changes to data on some tables, but don't want to implement a solution that tracks every change.
Error handling is one of those things that is simple to do in SQL Server, but most people don't do it and it's not the most rebust thing. Here's another way that you can implement error handling in your stored procedures from a new author Amit Jethva.
Have you ever built a join graphically using Access or Visual Studio? Did you know that you can do this with the native SQL Server tools? And it's easy! Follow along as Dale Corey shows you how.
The fourth and final installment in this series, this week Andy discusses how using XML can reduce the load you put on your network and on your server. This is a high level article that discusses concepts. We think you'll find a good idea or two in this one!
Lumigent Technologies today announced that they are a recommended supplier to provide data auditing solutions for risk management to customers of Microsoft SQL Server 2000 through their Entegra product. Enterprises that depend on SQL Server databases can now rely on Entegra as a trusted auditing solution to enable compliance with regulatory requirements.
The error handling in SQL Server leaves something to be desired, especially compared with other RDBMSes and languages. The standard method of testing for errors can leave your code bloated and hard to read. Stefan Popovski looks at another method of handling errors.
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Altira Bussiness Park, Jl. Yos Sudarso Kav 85 Blok B No.1-2, Sunter Jaya, Kec....
BCA KCP Soepomo Telpon/WA:08137887595.Alun Graha, Jl. Prof. DR. Soepomo SH No.233 Lt. Dasar, RT.007/RW.1,...
Komplek Ruko, Jl. Soka 1 Jl. Terusan Bandengan Utara No. 95 G-H, Pejagalan, Kecamatan...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers