More On Column Order Indexes – Part 2
Continued analysis of index architecture with revised clustered index. Part 2 of Column Order Indexes
2019-04-24
189 reads
Uncategorized
Is AI human-ready?
Aleksander Madry discusses roadblocks preventing AI from having a broad impact and approaches for addressing these issues.
Continue reading Is AI human-ready?.
2019-04-17
8 ways for banks to use AI
If a bank gets in touch with a software company and wants to know how it could use artificial intelligence (AI), that means two things. First, the bank is...
2019-04-16
Here and now: Boosting anti-money laundering efforts with Artificial Intelligence
Anti-money laundering has been an issue for banks and financial institutions for some time. Transaction monitoring systems have been around for many years. Meeting and complying with regulations at...
2019-04-15
Its time to accelerate the State of DevOps
Redgate is joining forces with DevOps Research and Assessment (DORA), now part of Google Cloud, as a sponsor of the 2019 Accelerate State of DevOps Report, and we're excited...
2019-04-11
More On Column Order Indexes – Part 2
Continued analysis of index architecture with revised clustered index. Part 2 of Column Order Indexes
2019-04-09
2,470 reads
Index Column Order – Be Happy!
Ever wonder about index column order; this piece should give some insight.
2019-02-28
2,328 reads
Cyber Insecurity in Pakistan
Journalist Alamzeb Khan discusses recent security breaches in Pakistan that have affected millions of people and accounts.
2019-01-31
3,554 reads
Creating and using inline table-valued functions
Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.
iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.
2019-01-22
8,352 reads
Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory)
With Azure Data Factory V2 Integration Runtimes (ADFv2 IR), you can deploy enterprise replication tasks to the Azure cloud.
2019-01-02
643 reads
Blogs
Being a Woman in the SQL Community
In celebration of Women’s History Month starting next week, I was asked to write...
Join me at SQLBits 2020
The SQLBits conference is taking place in London again this year, between March 31st...
DBA, a job, a vital job
DBA, a job, a vital job. T-SQL a language that is fun. Select, a...
Forums
SMO Certificate Export - FailedOperationException
Greetings, Given this Powershell SMO method call... $_cert.Export("$CertificateLocation\$_cert_name.cer", ` "$PrivateKeyLocation\$_cert_name.pvk", ` $_secret) where $_cert...
Resultset in a format
I have the following tables: create table #EmployeeSystemsMaster(EmployeeSystemID int, EmployeeSystemName nvarchar(150)) insert into #EmployeeSystemsMaster...
SQL Server data masking
Can you able to mask data in sql server 2012? If yes, would it...
Ask SSC