Size of the DB limit has changed...
The cool update from SQL Server 2008 R2 is the possibility from Express Edition that changed the database limit from...
2010-04-26
730 reads
SQL Server 2008 R2 Books OnLine - available now...
SQL Server 2008 R2 is released on April 21st, 2010 and in parallel with this new release, now is available...
2010-04-26
2,934 reads
Speaking at Auckland, New Zealand SQL Users Group
On Tuesday Morning at 2:00 am EST time I will be speaking at the Auckland SQLUsers Group. This will be...
2010-04-25
545 reads
Need Data from a Mac: TransMac for Reading HFS Volumes a Lifesaver
Recently I was handed over a HFS volume to read from my colleague who uses his Macbook exclusively. We had...
2010-04-25
1,042 reads
A DMV a Day – Day 25
The DMV for Day 25 is sys.dm_os_memory_cache_counters, which is described by BOL as:
Returns a snapshot of the health of a...
2010-04-25
1,700 reads
Reporting Services 2008 R2 Report Parts
Reporting Services 2008 R2 has many new great features that I’ve written about lately (Data Bars and Indicators). Today I...
2010-04-24
1,337 reads
A DMV a Day – Day 24
The DMV for Day 24 is sys.dm_exec_requests, which is described by BOL as:
Returns information about each request that is executing...
2010-04-24
975 reads
Besides Being a DBA, Do You Also Happen to be an Exchange Administrator?
I know a lot of DBAs fall into the category of part-time DBAs, because they work in small IT shops...
2010-04-23
552 reads
SQL Server 2008 R2 Road Show Recap
This past week I had the opportunity to speak at three SQL Server R2 Launch events.I spoke in three cities...
2010-04-23
403 reads
Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008
Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008
One of the features of SQL Server 2008 that...
2010-04-23
3,259 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers