SQL Server 2012 security: Changes for the newest version
Database infrastructure security is extremely crucial for any organization, which is why Microsoft has invested heavily in SQL Server security...
2012-12-11
1,170 reads
Database infrastructure security is extremely crucial for any organization, which is why Microsoft has invested heavily in SQL Server security...
2012-12-11
1,170 reads
Checkout my article here, in which I talked about the basic steps that are requried to plan an successful ETL...
2012-12-02
706 reads
Database technologies are an essential component of many information systems because they store a large amount of sensitive corporate data...
2012-12-02
808 reads
Checkout my article here, in which I discussed the fundamentals of XML technologies.
This article is published on SSWUG.org.
2012-12-02
633 reads
Problem
After recently upgrading a SQL Server instance to SQL Server 2012 a few days ago, you noticed that your application...
2012-11-15
1,902 reads
Reblogged from Basit's SQL Server Tips:
This article walks the user through installation of SQL Server 2012 on a Windows Server...
2012-11-11
1,271 reads
The database expansion costs money, not just software licenses. It costs money in maintenance and hardware, and also impacting businesses...
2012-11-11
1,072 reads
Before SQL Server 2012, when we move or restore databases to a different SQL Server instance, then any logins associated...
2012-10-24
878 reads
Problem
The SQL Server Database Engine returns the following error message after a service broker enabled database is restored to the...
2012-10-24
3,697 reads
Locking is a necessary part of transaction processing when working in a multi-user Online Transaction Processing (OLTP) environment. You use...
2012-10-21
12,275 reads
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
Comments posted to this topic are about the item Life Moves Pretty Fast
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...
Comments posted to this topic are about the item 50 Years of Microsoft
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers