List Objects in a Filegroup in SQL Server 2005
I have tried hard to google a SQL query to find what objects exist in a specific filegroup, but in...
2009-01-16
12,543 reads
Blog Posts
Loading Up For Travel
I fly to the UK tomorrow, not really my favorite thing to do, so I’m trying to ensure I can...
2009-01-16
786 reads
Comments on Pro Full-Text Search in SQL 2008 by Michael Coles
Apress sent me a free review copy, so I took a quick look through it at lunch. I've used full...
2009-01-15
604 reads
devLINK Technical Conference to Be Held in Nashville, TN in August
The 2009 devLINK Technical Conference will be held in Nashville, TN, August 13-15, 2009. This three-day conference provides technical content...
2009-01-15
474 reads
Have you disabled autoplay yet?
If not, you should. Because autoplay being on means any time a removable data device, such as a USB stick,...
2009-01-15
748 reads
Honoring a Contest
Over the last six months or so, Pepsi has been running a PepsiStuff promotion on many of their products. They...
2009-01-15
645 reads
How Humans Behave
It is strange how people react in different circumstances. Yesterday while going through the forums, there was an interesting post....
2009-01-15
444 reads
Microsoft Solution Accelerators on TechNet
I was browsing through the new titles that are on Safari and saw some planning guides around Windows Server 2008...
2009-01-15
816 reads
PASS BI SIG
Yesterday I participated in my first BI SIG live meeting. This special interest group is led by Amy Lewis who...
2009-01-15
671 reads
Thanks to PASS - Free Laptop
It seems like the benefits of being involved in PASS just never stopped. If you didn’t see the PASS newsletter...
2009-01-15
575 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
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...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers