Learning SQL Server
Learn about the core SQL Server concepts to build your skill set including the architecture, database design, development, administration and more.
2021-02-24
Learn about the core SQL Server concepts to build your skill set including the architecture, database design, development, administration and more.
2021-02-24
Introduction In my last article, Discussion on Normalization and Database Design Concepts, I discussed about the normalization concepts. Here, I will take one table in SQL Server and implement different normal forms. As we move up the higher normal forms, we end up on more number of tables. Implementation of Normal Forms Let us start […]
2021-02-22
3,282 reads
When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]
2021-01-25
10,249 reads
Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]
2020-09-24
1,191 reads
As you may know, SQL Server is a very robust database, but SQL server has its performance bottlenecks. With the introduction of In-Line memory OLTP, there is a chance to get rid of the performance bottlenecks
2014-09-16
6,440 reads
This article provides a solution to executes 32 bit SSIS packages in 64 bit environment.
2013-10-14
6,173 reads
Day 3 of Security Week at SQL University is now in session. You're implementing a third party solution and you...
2011-02-11
2,330 reads
I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...
2009-10-01
7,587 reads
I am using vb6 with adoI was used to use addnew with a recordset but so I will use somthing like "insert into dbo_invoice (invoice_id, invoice_date) select max(invoice_id)+1 as new_id, getdate() from dbo_invoice"what will gurantee that using rs.open "SELECT @@IDENTITY AS 'Identity'" will return the Id created by the application current user and not by […]
2004-12-03
QUIT DOUBLE POSTING!If people have an answer to your question they will post it. If you aren't getting an answer it's because:1. no one has an answer 2. no one understands what you are asking-SQLBill
2004-04-28
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers