SSC Editorial: Infect Your Colleagues with the Learning Bug
If you work with colleagues that aren’t as interested in growing and learning as you are, I hope you’ll read...
2014-07-14
646 reads
Blog Posts
The SQL Sac wrap!!
Every SQL Saturday leaves a mark of some sort. This time around, the folks in Sacramento have really helped leave a BIG mark. That’s right, this last weekend was...
2014-07-14
11 reads
The SQL Sac wrap!!
Every SQL Saturday leaves a mark of some sort. This time around, the folks in Sacramento have really helped leave...
2014-07-14
741 reads
Whitelist a Set of IP Addresses in SQL Server
Blacklist vs Whitelist
Are you on the Whitelist?
I think just about everyone is familiar to some degree with the concepts of...
2014-07-14
4,069 reads
Creating a Matrix Infographic in SSRS
With “Matrix Infographic” I simply mean those infographics FiveThirtyEight (site | Twitter), the website of statistic revelation Nate Silver, uses to...
2014-07-11
1,085 reads
Examining OLEDB waits
On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this...
2014-07-11
3,508 reads
Examining OLEDB waits
On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this article we...
2014-07-11
596 reads
Free Ebooks From Microsoft
Probably you’ve heard about it already, but a quick post just in case – you can download a 100 or so...
2014-07-11
1,011 reads
Friday Followup For July 11, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-07-11
293 reads
Notes from the July 2014 ONETUG Meeting
Rained as I left (early) for the meeting, confirming again why I always leave early – stuff happens (in Orlando, rain...
2014-07-11
682 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