SQL University: SQL Server Security Architecture - 3rd Party, Some Options
Day 3 of Security Week at SQL University is now in session. You're implementing a third party solution and you...
Day 3 of Security Week at SQL University is now in session. You're implementing a third party solution and you...
Support for SQL Server 2005 expires in April. Should you care? Steve Jones thinks it might not be a big deal for many people.
Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information...
Learn Integration Services from SSIS expert and MVP, Andy Leonard in March. This 5 day class will be held on Mar 21-25, 2011 in Farmville, Virginia.
As a DBA you always followed a practice to back up your database (or take a snapshot of your database) before making any changes so that you can revert to your old database state if something goes wrong. Also to setup a development or test environment you use a backup of your database and restore it in the respective environment. If you are moving to SQL Azure, what would you do in these cases as backup / restore and database snapshots are not supported as of now?
An interesting tutorial for linking SQL Server to a Blackberry device and viewing images.
A series from MVP Jessica Moss designed to help you understand Reporting Services and begin building reports.
Are there things you should know? It seems that we quite often find that others in our profession don't understand the simple things we assume they do. Steve Jones talks about one item in particular: staging servers.
Way back in January, 2008, I wrote a blog post called “Five DMV Queries That Will Make You A Superhero!”...
SEQUENCE is a core new feature of SQL Server 2011 (Denali). It is a more performant, flexible alternative to the INDENTITY attribute. This article introduces sequence and demonstrates how to use it and its performance advantage.
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WA:08218154393 Jl. Sam Ratulangi No.17-19, Wenang Utara, Kec. Wenang, Kota Manado, Sulawesi Utara 95111
WA:08218154393 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi Selatan 90231
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers