Reporting Services and Windows 7 Home Premium
Ok, continuing from my post last night about the ‘Run as Administrator’ bug in SSMS, here’s the other half of...
2010-04-13
809 reads
A DMV a Day – Day 13
The DMV for Day 13 is sys.dm_io_virtual_file_stats, which is described by BOL as:
Returns I/O statistics for data and log files....
2010-04-13
1,202 reads
T-SQL Tuesday – The Reporting Table
My T-SQL Tuesday post for April is based on Aaron Nelson’s subject of reporting. If you’re unsure of what T-SQL...
2010-04-13
1,454 reads
T-SQL Tuesday #005: SSIS Reporting
Automating SQL Server Integration Services (SSIS) administration through PowerShell is very different than writing scripts against the core database engine....
2010-04-13
1,204 reads
T-SQL Tuesday #005 – Self Service Performance Information
Introduction
Today I am taking a little detour from the scripts I have been posting to take part in “T-SQL Tuesday...
2010-04-13
435 reads
Bug: Reporting Services 2K8, SSMS and Windows 7
[Edit] Since writing this, I've realized that the true reason behind this was that my account was not a member...
2010-04-12
1,126 reads
How Can I Tell if a Windows Login has Rights to My Server?
Introduction
Here is another utility stored procedure that I use. This stored procedure will tell you how a user has access...
2010-04-12
317 reads
Reporting Services 2008 R2 Data Bars
Last week I wrote a blog explaining how the new tool inside Reporting Services 2008 R2 called Indicator will be...
2010-04-12
2,088 reads
Visual Studio 2010 Download Interruptus
Microsoft has made the RTM bits for the various versions and components of Visual Studio 2010 available on MSDN Subscribers...
2010-04-12
336 reads
Seacoast SQL Users Group
Tomorrow is the Seacost SQL Server User’s Group inaugural meeting. I’ll be presenting a session called “Understanding Execution Plans.” It’s...
2010-04-12
735 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage
Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL...
DBCC CHECKDB Limits II
Comments posted to this topic are about the item DBCC CHECKDB Limits II
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers