Using SQL Server and R Services for analyzing Sales data (Part 3)
Using R integration for analyzing sales data in WideWorldImporters database
Which Version of SQL Server Should You Use?
Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version?
Forgiveness
Learning active forgiveness can be a challenge, but it may help you build a better team.
Protecting SQL Server Data Using Static Data Masking
In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and testers must not contain private and sensitive data from production databases. To help DBAs protect data, Microsoft have released a new feature as part of SSMS called Static Data Masking. In this article, Greg Larsen demonstrates how to use this new feature.
Complex Constrained Security
Setting up your authorization and security can be fairly easy, but perhaps we ought to consider more complex scenarios.
Import data dynamically using R and Python in Power BI Desktop
Learn how to import data into Power BI using either R or Python scripts.
DR Planning
Disaster recovery planning can be hard, and we often forget about some of the non technical issues.
Better Code Reviews with GIT
As more dev teams move their code to Git, it’s important to understand the differences between it and other tools they have used in the past. In this article, Michael Sorens provides some good advice about doing code reviews with Git.
Creating Your First Stored Procedure
Learn how to get started writing code modules inside of your SQL Server database,
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
An Unusual Identity
Comments posted to this topic are about the item An Unusual Identity
Dancing Robot Goes Rogue
Comments posted to this topic are about the item Dancing Robot Goes Rogue
advice as i migrate my winscp based ssis pkg to our prod server
Hi , i installed winscp on my pc, added it to GAC thru vs...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers