Passwords Under Pressure
Passwords are a problem, especially when we're in a hurry. What should we do?
Introduction to Azure SQL Database Temporal Tables
As announced on June 1, 2016, SQL Server 2016 has reached its general availability. This means that you finally have the option to implement some of its new features in the production environment. While we still have to wait for their full support in Azure SQL Database V12, it is likely that their preview stage will be concluded soon. In this article, we will focus on Temporal tables, which is one example of these new features.
How Far Have You Traveled for a SQL Saturday?
This Friday Steve Jones talks SQL Saturdays and asks how far you've traveled to attend one.
Execute SQL Server DBCC SHRINKFILE Without Causing Index Fragmentation
Simon Liew shows how to execute SQL Server DBCC SHRINKFILE without causing index fragmentation and example conditions that cause fragmentation.
Data Quality - Addressing non-stated requirements
Producing a crib sheet for data quality drives a shared understanding of the data used to power the business.
Too Much Information for Sports
Gathering too much data isn't always helpful, and doesn't necessarily help you make better decisions. However, that's up to you to decide how much is too much.
A Real-World React.js Setup for ASP.NET Core and MVC5
React is a front-end user interface library developed by Facebook, originally to help them improve their own site. Since then it has grown into somewhat of a phenomenon, with many active users. In this article, Jon Smith provides multiple examples of how to use React with recently released ASP.NET Core MVC, and the existing ASP.NET MVC5 framework.
Learning to Search
Today Steve Jones notes that the ability to search if invaluable as the amount of information, or even objects, we deal with grows.
Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL
A guide to using databases, schemas and tables in Azure Data Lakes, using (of course!) U-SQL.
Temporal Data Part 2 - Creating and Deleting System-Versioned Tables
Greg Larsen expands on his topic of how to modify an existing table to take advantage of the new temporal data feature in SQL Server 2016. In this article he shows you how to create and deleted system-versioned tables and the associated history temporal table.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
BCA KCU MUARA KARANG No.Telpon 087781685647
Whatsapp 087781685647 Jl. Muara Karang Timur, Blok B VIII No.116-117, RT.6/RW.12, Pluit, Kecamatan Penjaringan,...
BCA KCU MENARA BIDAKARA No.Telpon 087781685647
Whatsapp 087781685647 Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1, RT.1/RW.1, Menteng Dalam,...
BCA KCU PLUIT No.Telpon 087781685647
Whatsapp 087781685647 Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit, Penjaringan, North...
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers