My network admins have tightened down the network and while we were once able to connect to our named instances via MySQLServer\MyNamedInstance, we're now only able to connect if we specify the port. What happened and what do I need to tell them to fix the issue?
Focusing in one area for long periods of time is hard. Steve Jones thinks that people taking a little time at work to recharge is a good idea, and something companies might want to encourage.
It is more and more essential for developers to work on development databases that have realistic data in both type and quantity, but without using real data. It isn't exactly easy, even with third-party tools to hand. Phil Factor shows how it can be done, taking the classic PUBS database and giving it a more realistic set of data.
Today Steve Jones talks about security and his desire to have certificates be the primary means of securing communications and verifying authenticity.
CAN you create AND USE an indexed view in non-Enterprise Editions of SQL Server?
I have transactional replication configured in production. I am wondering if we could rename the publication database in transactional replication without having to drop and recreate the replication set up. Also, is it possible to rename the database files of the publication database without affecting the replication configuration.
SQL Saturday comes to Wisconsin and Madison on Apr 21, 2012 with world famous brats for lunch. Sign up for a free day of SQL Server training.
There's an IT skills gap in many companies, which is forcing managers to get creative. Steve Jones says now is the time to look for some cross training at work.
Are multiple binary switches becoming hard to manage? The TestBits function can help with that.
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item SQL Server Still Wins
Comments posted to this topic are about the item DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers