Watch the Power Pivot 101 Webinar Recording
Thank you to everyone that attended my webinar titled Power Pivot 101: An Introduction! Also, thank you to Thomas Leblanc...
2015-09-14
652 reads
Blog Posts
Webinar – SSIS Best Practices and Tuning Tips
I’ll be giving an SSIS webinar for MSSQLTips.com on Tuesday 15th September 2015.
The title is SQL Server Integration Services Best...
2015-09-14 (first published: 2015-09-08)
2,673 reads
Webinar: Change Tracking for Data Warehouse Loads
For data warehouse professionals, change detection is critical. Accurately detecting new, changed, and deleted records means the difference between doing...
2015-09-14
533 reads
What SQL Server components are installed on this machine?
Figuring out what components of SQL Server are installed on a particular machine has always been a task that has...
2015-09-14
635 reads
Houston TechFest Presentation Downloads
Thanks for joining me at Houston TechFest 2015 at the NRG Center in Houston, TX! Big congrats to Michael and...
2015-09-13
483 reads
Step by Step SSIS learning What Data Conversion use in SSIS ? TIP#116
Dear Friends,
In the series of step by step learning of SSIS this is part #6 in which we are going...
2015-09-13
972 reads
Data Needed to Recover SQL server from a Host Crash
Am sure every DBA has once in his/her career come across a situation of recovering a database or an instance...
2015-09-12
301 reads
GAM and SGAM
In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for...
2015-09-12
858 reads
GAM and SGAM
In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for...
2015-09-12
461 reads
MOVING SYSTEM DATABASES
Below document provides information that can be used for moving system database. However this is not recommended for database installation...
2015-09-12
26,939 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