We Hired!
The response to our most recent job position was incredible, and I’d like to thank all of the folks who...
2017-02-21
403 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
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
Power BI Custom Visuals Class (Module 39 – Waffle Chart)
In this module you will learn how to use the Waffle Chart Power BI Custom Visual. The Waffle Chart visual...
2017-02-21
1,023 reads
Permanent Employment v Contracting: How the figures stack up
In my latest learning tree newsletter, I discussed analysing some of the salary survey data that the good folks over...
2017-02-24 (first published: 2017-02-21)
3,507 reads
Error while loading Excel data into database
Issue: I am trying to load data from Excel 97 – 2003 sheet into a database table. I have written a...
2017-02-28 (first published: 2017-02-21)
4,899 reads
How to sign a SQL Server CLR Assembly in Visual Studio 2015
It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR...
2017-02-22 (first published: 2017-02-21)
6,889 reads
Improve performance by replacing temp tables with memory optimized tables - Part 3
Welcome to the last part of this series, you can find the previous post here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/01/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-1/) and here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/08/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-2/).
Previously we...
2017-02-24 (first published: 2017-02-21)
5,105 reads
SQL Server vNext: sys.dm_db_stats_histogram
Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram...
2017-02-21
384 reads
External SQL files vs. Stored procedures in SSIS development
[2017-Feb-21] I'm creating this particular blog post more for myself to remember and use it as a reference to related discussions...
2017-02-23 (first published: 2017-02-21)
3,346 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...
Kantor Resmi BCA KCU CILACAP Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten...
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