Uniqueness of values in specific columns can be enforced in a SQL Server table by creating a unique constraint or a unique index on those columns. In this article, Sergey Gigoyan looks at what the differences between the two are, and how SQL Server handles them both.
2016-07-04
4,824 reads
Learn how to use SSIS to load Delimited Flat Files to staging tables.
2016-07-01 (first published: 2015-04-20)
12,817 reads
A number of new SQL Server PowerShell cmdlets have been released and the Microsoft is asking for feedback on what else you'd like to see.
2016-07-01
1,216 reads
David Fitzjarrell takes a look at why the mutating table error is thrown, why it's not going to create data problems, and how to possibly fix it.
2016-07-01
3,541 reads
This article demonstrates how to generate and save an SSRS report to a network folder when an SSIS package is executed.
2016-06-30
4,884 reads
It is a good time to get familiar with Azure SQL Data Warehouse. The first objective must be to get data into it. SSIS is a good way to start, and it’s certainly worth gaining confidence with the ETL processes supported by SSIS before setting off in other directions. Rob Sheldon provides a simple guide to getting up and running.
2016-06-30
3,793 reads
With PowerShell playing a more important role in administration of various types of servers, more SQL Server DBA candidates should have PowerShell knowledge and skills. In this article, Jeffrey Yao lists some common SQL Server DBA tasks that may be completed easier with PS than T-SQL.
2016-06-29
3,232 reads
Risk-averse managers are reticent to upgrade to the latest and greatest. Why is this the case and how can the savvy DBA make the case for and get ready for a newer version of SQL Server?
2016-06-28
2,896 reads
The solution here was to slightly modify the slow queries, so the index could be fully used. We made the queries Search Argumentable, or "SARGABLE."
2016-06-28
4,654 reads
This article will discuss geo-replication for an Azure SQL Database (PaaS) and the steps required for setup via the Azure portal and TSQL.
2016-06-27
1,945 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Whatsapp:08216977726 Jl. Panglima Sudirman No.1, Ngaglik, Kec. Batu, Kota Batu, Jawa Timur 65311
WhatsApp 08388331767 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan...
Whatsapp:087757645171 Jl. Raya Abepura, Vim, Kec. Abepura, Kota Jayapura, Papua 99351
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers