T-SQL Tuesday #59: My Hero
This month’s T-SQL Tuesday is hosted by Tracy McKibben (blog | twitter) and is all about heroes (not the TV show).
Ada...
2014-10-14
1,198 reads
T-SQL Tuesday #59 – My Hero!
It always amazes me how fast these T-SQL Tuesday block parties come about; it seems like we just finished one...
2014-10-14
610 reads
Operation Souza
This Wednesday we’re having a special joint meeting of oPASS and MagicPASS featuring Microsoft GM Mark Souza. For the past...
2014-10-13
861 reads
Last Weeks Top “Reading” Links #104
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-10-13
1,059 reads
Configure SQL Server Database Mirroring
1) Take Full backup of database at Principle Server BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’ 2) Take Log Backup at Principle Server BACKUP LOG USERDB1 TO DISK =...
2014-10-13
20 reads
Notes From the October 9, 2014 Space Coast SQL Meeting
Not a bad drive over from Orlando. Only a little traffic, about 80 minutes. I was early enough to have...
2014-10-13
926 reads
Tools For Successful Remote Working
I’ve been asked a few times recently how I find remote working and how well it works so I thought...
2014-10-13
52 reads
Creating a Reporting Services Subscription
Subscriptions are a great feature in Reporting Services that will run a report unattended and deliver it to users either...
2014-10-20 (first published: 2014-10-13)
8,100 reads
SQL Saturday Minnesota Precon 10/24 – Virtualization for SQL Server DBAs
Coming soon is the SQL Saturday #332 in Minneapolis, MN on October 25th, with my preconference training session on Friday, October 24. I am really looking forward to...
2014-10-13
1,160 reads
Creating a Reporting Services Subscription
Subscriptions are a great feature in Reporting Services that will run a report unattended and deliver it to users either...
2014-10-13
1,082 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