How can IT get along better with the rest of the business? Often a SQL Server DBA isn't in charge, but you can influence others and make everything work smoother with a little effort. Andy Warren gives you some tips and tricks that have worked well in the past.
2008-01-29
3,466 reads
Continuing on with his series on table partitioning, Andy Warren takes a look at some fo the advanced features available in SQL Server Enterprise Edition.
2008-01-17
7,236 reads
Continuing on with his series on SQL Server table partitioning, Andy Warren takes a look at how partitioned views are handled when you query them.
2008-01-08
7,929 reads
Most SQL Server DBAs have been taught that cursors are bad and should not be used. However there are some cases and places where they might be useful. SQL Server guru Andy Warren brings us an example of where they may be handy.
2008-01-03 (first published: 2007-01-15)
16,851 reads
In working on an existing database, DBAs often look to normalize tables and correct obvious flaws in design. Recently Andy Warren was working on a consulting project and realized that defaults would prevent many issues.
2007-12-28 (first published: 2007-01-04)
7,176 reads
What's the routine of a normal DBA job? Too many people work alone and don't get feedback or comments on what they should be doing from other DBAs. Andy Warren has jotted some notes down on what you should make sure is a part of your job.
2007-11-29
12,422 reads
The SQL Server community has a new event to attend in local markets. The Orlando Users Group put on SQL Saturday recently and here's a short look at how this event came about, and how you might run your own event.
2007-11-21
712 reads
From SQL Server trainer and guru Andy Warren, he are a few short nuggets that you might not realize about triggers.
2007-11-13
8,450 reads
Replication usually involves data, but it can also include stored procedures as well. SQL Server expert trainer Andy Warren brings us a look at how you can ensure that your stored procedures move as well.
2007-11-05
6,405 reads
For quick and dirty work, sometimes Access is the best way to work with SQL Server. Andy Warren brings a basic tutorial on how you can link Access to your SQL Server tables to easily and quickly manipulate data.
2007-11-02 (first published: 2006-01-25)
27,002 reads
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers