Stored Procedure Definitions and Permissions
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
2011-03-14
2,788 reads
Blog Posts
The Lighter Side of Technical Interview Questions
I hate those puzzle type interview questions. I am sure that they show some level of aptitude about something, but...
2011-03-14
1,016 reads
March PASSMN Meeting This Week
I mentioned the PASSMN meeting last week and thought a reminder might be worthwhile. Just in case you head has...
2011-03-13
582 reads
SQLPSX 2.3.2.1 Release
We’ve released a minor update to SQLPSX which includes includes several bug fixes/enhancements as well as one new module. Here’s...
2011-03-13
1,029 reads
Do you know SqlServer ? Do you want an iPad ?
If you’ve answered yes to both of those questions , Jacob Sebastian has some more question for you.
Every day in March...
2011-03-12
540 reads
INDEX DEFRAGMENTATION SCRIPT for SQL server 2000
Advertisements
INDEX DEFRAGMENTATION SCRIPT SQL 2000
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance....
2011-03-12
1,887 reads
Table-Valued parameters in SQL Server 2008
Introduction
The
most awaited feature has arrived - "Table-Valued parameters in SQL Server
2008". Here, I would discuss on how to use this new...
2011-03-12
4,523 reads
A Small Collection of SQL Azure Queries
We have been doing some more work with SQL Azure lately, so I have put together a small collection of...
2011-03-11
2,549 reads
MagicPASS March 2011 Meeting Notice
If you're in the central Florida area you're invited to the March meeting of MagicPASS, South Orlando's SQL Server User...
2011-03-11
483 reads
Monitoring Database Infrastructure and Performance with Systems Center Operations Manager (SCOM), and Oracle Instance Monitoring, Plus Visio Plug-In
SCOM Does the core job of monitoring SQL Server instances very well (Health Monitoring) – but it is not going to...
2011-03-11
8,987 reads
Blogs
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers