Partial name matching in SQL Server 2011 “Denali”
While playing with SQL Server 2011 “Denali”, I’ve accidentally found out that it has slightly enhanced intellisense in SSMS. There...
2011-07-21
1,381 reads
Blog Posts
PowerPivot - Diagram View
The new “Denali” PowerPivot has a lot of fanatic new additions that I’ve really been looking forward to.Many of my...
2011-07-21
2,646 reads
SQL Server Denali CTP3 Download
AdvertisementsMicrosoft has given the SQL Server Denali CTP3 (Community Technology Preview) for public preview. You can download the SQL Server Denali CTP3...
2011-07-21
951 reads
SSWUG Spring Conference Speaker Ratings
This spring I presented a few sessions at the spring SSWUG virtual conference – DBTechCon. Now that the event is over,...
2011-07-21
1,032 reads
Tallahassee User Group meeting August 9th
For those of you in the Tallahassee, FL area on August 9th at 6:00 pm I will be speaking virtually for...
2011-07-21
768 reads
Trusts Are Transitive
If you’ve done networking in the MS world you know about the trust options between domains, and one of the...
2011-07-21
975 reads
Announcing SQL Saturday #99
Seriously, what’s going on in Minnesota? Our government is shut down and… we are hosting a SQL Saturday on a...
2011-07-20
663 reads
BI on SQL Azure
Introduction
A newly emerged concept ‘cloud computing’ is a phenomenon which is quickly embedding into all sectors of IT industry. Data Warehouse (DW) and Business Intelligence (BI) is...
2011-07-20
21 reads
BI on SQL Azure
Introduction
A newly emerged concept ‘cloud computing’ is a phenomenon which is quickly embedding into all sectors of IT industry. Data...
2011-07-20
530 reads
Can You Endorse Me?
“Hey man, this is Ty*, what’s happening?” roared the familiar voice in my Bluetooth earpiece. It was a voice I...
2011-07-20
1,251 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