Reminder – SQL Saturday Chicago Precon
I just wanted to remind everyone that the SQL Saturday in Chicago is coming up, and that both Adam Machanic...
2017-02-22
356 reads
Blog Posts
Remotely Administering the Docker Engine on Windows Server 2016
Continuing on my series in working with Docker on Windows, I noticed that I always open up a remote powershell...
2017-02-22
708 reads
SQL Code Guard 2.9 released
Nothing special - just signed with renewed code sign certificate, small fixes, etc
Have fun!
Wait a minute! Almost forgot.
More great news coming...
2017-02-22
814 reads
SSMS Presenter Mode
SQL Server Management Studio (SSMS) release candidate 17.0 RC2 works side-by-side with generally available releases (16.x), but it is not...
2017-02-22
576 reads
What’s a DACPAC and a BACPAC?
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-02-22
1,146 reads
What’s in my backup file?
Restoring a backup file is pretty easy right?
RESTORE DATABASE [Test] FROM DISK = 'C:\backups\backup.bak';Ok, but what if more than one database...
2017-02-22
956 reads
Giving a Security Webinar on Thursday
On Thursday, February 23rd at 3 PM EST I’m giving a webinar on designing a successful database security model with...
2017-02-21
373 reads
Heading Back to SQL Bits
I’m honored to be selected to speak at SQL Bits 2017 this April in Telford. This is my favorite SQL...
2017-02-21
566 reads
JSON Support Is The Best New Developer Feature in SQL 2016 — Part 4: Performance Comparisons
This is the fourth article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON,...
2017-02-21
37 reads
Managing Bad Data
In the last post in my ongoing series about ETL best practices, I discussed the importance of error handling in ETL...
2017-02-21 (first published: 2017-02-16)
2,212 reads
Blogs
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...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Magetan Hub/Wa. 0817-819-444
Jl. A. Yani No.25 B, Dusun Onggoprayan, Kepolorejo, Kec. Magetan, Kabupaten Magetan, Jawa Timur...
Layanan BCA KCU MADIUN Hub/Wa. 0817-819-444
9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132
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