Disabling #sqlprompt Formatting
I love SQL Prompt, especially the new formatting engine. However, it’s not perfect, and there are times I don’t want...
2017-01-31
951 reads
Blog Posts
Hiring Productive Employees – #TAPtips
Starting a business is easy. Have an idea, some skills, a customer or two, and you are in business. However,...
2017-01-31
652 reads
How to Count the Total Number of Rows Across Multiple Tables
I have been working on SQL Server Consulting assignment, a SQL Server 2014 migration for a new client over the...
2017-01-31 (first published: 2017-01-22)
45,388 reads
Join webinar on SQL Server 2016 Always on
Click [HERE} to Join webinar.
SQL Server 2016 - AlwaysOn
An availability group supports a failover environment for a discrete set of user databases, known...
2017-01-31
558 reads
JSON Support Is The Best New Developer Feature in SQL 2016 — Part 2: Creating JSON
This is the second 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.
Part...
2017-01-31
32 reads
My First SQL Saturday – As A Speaker!
I am so honored and excited to have been selected to speak at SQL Saturday Richmond on March 18, 2017.
I...
2017-01-31
611 reads
Pesky Percent File Growth
As DBAs we all know setting your file growth to grow by percent is not optimal. It can cause all...
2017-01-31
754 reads
Power BI Custom Visuals Class (Module 35 – Box and Whiskers (Jan Pieter))
In this module you will learn how to use the Box and Whiskers (Jan Pieter) Power BI Custom Visual. This...
2017-01-31 (first published: 2017-01-24)
1,761 reads
Speaking at Techorama 2017
I’m delighted to announce that I’m selected as a speaker for the Techorama event.
Techorama is a developer congress focusing (but...
2017-01-31
678 reads
SQL and the other technologies
I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is...
2017-01-31
548 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