Most customers and clients wants highly available systems, with 100% uptime if possible. However most don't want to pay for them, and eventually tolerate some outages to keep costs down. This Friday, Steve Jones asks what is your environment like.
Passwords control most of our access to computer systems and provide some level of authentication, but their security depends heavily on their strength and privacy. Steve Jones says you can set a good example for others and hemp improve security on all systems.
Transaction Replication Publisher failover/failback to mirror standby with automatic redirection of the subscriber and client application.
PowerShell is becoming a great tool for managing SQL Server tasks, but like most tasks that are coded there is always the need for error handling to deal with the unknown. PowerShell has several options for handling and capturing error details and in this tip we will explain these options using PowerShell for SQL Server examples.
Occasionally, a DBA may need to restore a database from a multiple backup files that originated from multiple servers. This requirement might arise, for example, in a database-mirroring configuration, where backups may be from either of the servers.
The things that are important to Microsoft might not be the same ones that are important to you as a customer. However Steve Jones thinks that the potential changes in the release strategy may be good for data professionals.
A deceptively simple solution to a business re-engineering problem can beguile companies into selecting a compromise that doesn't actually meet all their needs. Simple is great, but not at the expense of functionality. Some IT solutions are complex because the problem is complex, but they can be made conceptually clearer.
Some tips on what to do when you inherit a database that you've never worked on before
Not everything in SQL Server is documented and Steve Jones doesn't think that everything should be. However some features are used often and should have additional documentation.
This article will show some common integer data-type conversions using T-SQL.
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...
Untuk membuka blokir Mobile Banking permata bank , Anda bisa menghubungi Call Center permata...
Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...
Jl. Daan Mogot No.48 A, Jelambar, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
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