Cardinality Estimation in SQL Server
Each time you view a seek/scan operator in an execution plan, you may have noticed that there’s a value for...
2014-11-04
1,312 reads
PASS Summit 2014 Diary – Day 1
Today is the first day of official activities for the week. The PASS Summit hasn’t yet started, but I’ll be...
2014-11-03
772 reads
5 things to know about Databricks
Databricks is now available in both AWS and Azure so it’s getting a lot of buzz! Let’s discuss 5 things you should know about Databricks before diving in. 1. ...
2014-11-03
44 reads
What is a data warehouse and why do I need one?
While the data warehouse isn’t a new concept, many are left wondering – what is a data warehouse? And why do I need one? I’m sad to tell you...
2014-11-03
24 reads
Implementing Tabular Data Models: Microsoft Virtual Academy
Implementing Tabular Data Models
Date: November 11, 2014
Time: 9am?5pm PST
Where: Live, online virtual classroom:
http://www.microsoftvirtualacademy.com/liveevents/implementing-tabular-data-models
Cost: Free!
Register today! (linkto: http://www.microsoftvirtualacademy.com/liveevents/implementing-tabular-data-models)
What will you do...
2014-11-03
2,012 reads
Last Weeks Top “Reading” Links #107
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-11-03
472 reads
Setting Expectations–T-SQL Testing
I don’t know who started this pattern, as I’ve seen it in a few places. It could have been Sebastian...
2014-11-03
889 reads
SQL Server Database Mirroring Monitoring
SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of Database Mirroring to ensure that everything is working...
2014-11-03
22 reads
My DTS Package won’t load with the error “here were errors loading package”
You are trying to open a DTS package (yes some people still use DTS packages) and receive the following error:
Error...
2014-11-03
794 reads
SQL Server Table Partition Example
Why Use a SQL Server Table Partition
Data warehouses and data repositories often have tables that store millions of records and...
2014-11-03
5,197 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers